SQL Server Shrink – Maintenance
29-Oct-1010 Leave a comment
Does not always work straight off bat:
- Need to backup both database and transaction log regularly and possibly before shrink
- Try shrinking Database
- Try shrinking Database File and Transaction Log File
- Repeat above sequences until files shrink
There may be something blocking the shrink. Try the following query. Should return NOTHING in the second column.
If LOG_BACKUP then the space may not be released until a log backup is done.
SELECT name,log_reuse_wait_desc FROM sys.databases ORDER BY name