Tag Info

New answers tagged


Caveat: how big is the data load? There is quite a difference between 20G of data with 200G of empty space (in which case I would suggest a shrink) and 2000G of data with 200G of empty space! The drive is not in danger of filling up Space is not needed else where on the SAN In that case I would err on the side of leaving it as it is, especially if ...


Presuming you are sure the database is not going to need the 200+ GB of extra space it is currently consuming, I would recommend performing a shrink without reorganizing pages, using TRUNCATEONLY: DBCC SHRINKFILE (N'<file name>' , 0, TRUNCATEONLY); TRUNCATEONLY simply truncates the last part of the file without moving rows inside the data file. ...

Top 50 recent answers are included