question

nidheesh.r.pillai avatar image
nidheesh.r.pillai asked

Why did the .bak size drop after a full database backup?

So, I noticed this recently when I was doing a full database backup on one of our test servers. As the backup is executing, the filesize on disk shows 21,346,988 KB . Once the backup completed, the filesize on disk became 13,900,567 KB. I have not seen such a thing happen to other databases. The usual I see is a minor variation where the filesize grows a little more than initial. But not drop back like 7GB as what is happening is here. Why would such a thing happen?
sql-server-2008-r2backups
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

JohnM avatar image
JohnM answered
Are you using compression?
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

nidheesh.r.pillai avatar image nidheesh.r.pillai commented ·
And I got the answer! Thankyou :-)
1 Like 1 ·