Monday, 12 August 2013

Best way to reduce physical space of DB

Best way to reduce physical space of DB

i have a problem. My SQL Server is soon running out of space. I've already
tried to delete some unused tables in different DBs but that doesnt change
the free disk space somehow. I read about some commands to shrink the
database, but found several articles why not to use them.
http://www.brentozar.com/archive/2009/08/stop-shrinking-your-database-files-seriously-now/
Now i wanted to ask what i should do. on the server itself i've seen that
the tempdb.mdf file uses the most space. i'd like to get rid of the
problem, but i dont know what to do without causing some trouble. is there
a secure way to reduce the DB size of the tempdb? i'm sure that the tempdb
has some old temporary data in it, because its more than 177GB big. and
the other databases summed up are not more than 10GB.
Thanks in advance for your posts!

No comments:

Post a Comment