RE: Discrepancy in gigabytes between a bak file and restored database

SSC Guru

Points: 1003863

October 18, 2012 at 4:09 pm

kaplan71 (10/18/2012)
Hello --
I tested the database by connecting to it via a client application. The test was successful.
I spoke with several colleagues about the discrepancy, and they made mention of the fact the file itself is not compressed, nor is there any page compression within the database. These can probably explain the difference.

That and the fact that the freespace already mentioned doesn't get saved in the backup.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)