patternsqlMinor
if database is not shrinked does it affect backup size?
Viewed 0 times
sizeaffectdatabaseshrinkeddoesnotbackup
Problem
Ok my question is simple.
Lets say that when i click database and hover over shrink it says it can be reduced 1 GB space.
Now when i do a backup of this database, does this space also getting added to the backup file or backup process is somewhat special and it already shrinks it ?
SQL server 2012
Lets say that when i click database and hover over shrink it says it can be reduced 1 GB space.
Now when i do a backup of this database, does this space also getting added to the backup file or backup process is somewhat special and it already shrinks it ?
SQL server 2012
Solution
The backup process does not back up empty pages, only pages with data, so typically, the backup file will be a lot smaller.
One important thing to note: when using compression, the initial size needed on the destination drive will be the uncompressed size; the backup will only be fully compressed at the end of the process.
One important thing to note: when using compression, the initial size needed on the destination drive will be the uncompressed size; the backup will only be fully compressed at the end of the process.
Context
StackExchange Database Administrators Q#53176, answer score: 5
Revisions (0)
No revisions yet.