Why you should not shrink your data files?

Question

Shrinking of data files should be performed even more rarely, if at all. Here's why: data file shrink can cause *massive* index fragmentation (of the out-of-order pages kind, not the wasted-space kind) and it is very expensive (in terms of I/O, locking, transaction log generation). 24 июн. 2009 г.

Why you should never shrink a database?

It's an unbelievably, disgustingly, repulsively bad idea. Your disk drive space is for files, not for ornamentation. You don't get bonused based on the amount of free space on your drives. Empty files don't take longer to back up.

Is it safe to shrink data file?

Precautions. If you want to shrink the reserved space of the database after you delete data and the reserved space needs to be increased later as data is inserted again, then this procedure may create physical disk fragmentation and affect performance.

Should I shrink database or files?

Databases tend to grow as more data gets put in them. It's in their nature. Shrinking causes massive fragmentation and will just result in the data file growing again next time data gets added. When that happens, the entire system will slow down as the file is expanded.

Is Shrinking database good?

SQL SERVER – Shrinking Database is Bad – Increases Fragmentation – Reduces Performance.

Expert · Answer