Search This Blog

Thursday, 16 May 2013

SP2010: Database has large amounts of unused space.


This error i have seen a few times.

You need to Trunk your log file:

Following databases have large amounts of space allocated on the disk but not in use. This may be due to recent deletion of data form the database, or because the database has been pre-grown to a larger size. This database will take up a larger amount of space on the file system unless it is shrunk down to a smaller size.

Do this following:
Backup your DB,
Change recovery mode to simple
Right click on the DB it is warning you about and select Shrink and database

You can also do a Transaction log backup which should truncate it.
If you just need to shrink your Log file choose files and select Log File

No comments:

Post a Comment