RE: Backup size – SQLServerCentral

SSC Guru

Points: 61136

August 20, 2012 at 6:00 pm

GilaMonster (8/20/2012)
Actually it probably will be.
That query returns the total size of the DB files. A backup does not back up the entire file, just the used portion of it. So....

Good catch. Did not think about unused space. :blush:

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001