Hi, our clients live data files are something like 4gb in size, but theres a tempdb.mdf that continues to grow to 16GB!!!! Ive googled it & found that if you stop & start SQL server in services, it reduces this to something more normal like 50Mb. Sure enough it does exatly that
weve therefore set up a schedule to stop & start SQL server at 11pm This isnt ideal as its adding a variable in, in case something goes wrong. Ive noticed today that its now 500mb - does anyone have any ideas why is growing i size & how we stop it, other than constantly stopping & restarting SQL server please?