SQL Server Performance Forum – Threads Archive
Database shrinkingI have a database of 30 GB and the free avail. space is around 15 GB in MDF file. The system is running short of data drive space, and I believe I should shrink the db mdf file to free the space. Any comments, suggestions on my approach. Thanks in advance. RoyalSher.
The world is the great gymnasium where we come to make ourselves strong.
Yes dbcc shrinkfile() or shrink db() will give you more freespace on the drive. Beware of NTFS file fragmentation and internal table/index after shrinking, and also it’s quite an intensive operation so best run at a time of little/minimal use.
DBA, Oxfam GB
Ensure to maintain full database backup before this event. Ensure to maintain regular intervals of Transaction log backup. Shrinking a database is a fully logged event, which allows for normal recoveries, except in the case of the Master database. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.