Home Forums SQL Server 2008 SQL Server 2008 - General When is shrinking a data file acceptable? RE: When is shrinking a data file acceptable?
Dan.Humphries
SSChampion
Points: 12125
More actions
June 16, 2011 at 2:33 pm
#1340076
The Full DB Backup runs about an hour when it is at a TB but less then 10 minutes when it is reduced to the 100GB size.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.