Home Forums SQL Server 2008 SQL Server 2008 - General When is shrinking a data file acceptable? RE: When is shrinking a data file acceptable?
Ninja's_RGR'us
SSC Guru
Points: 294069
More actions
June 16, 2011 at 3:16 pm
#1340089
Ya but to pick only the used pages you must scan all pages (even if only the header). So that's an extra 200 - 900GB??? to extract from the san.
That's the only way I see to have such a huge difference in the times... for the same backup file size.