question

ManishSharma avatar image
ManishSharma asked

Why is the .bak file from Sql Server 2014 is bigger in size as compared to .bak file from Sql Server 2008 for same database

Hi,

I have taken backup of a database from Sql Server 2014 and found that the size of the backup file is bigger as compared to the size of backup taken from Sql Server 2008 of same database.

difference is quite significant, can anyone guide me for the same.

Regards.

sql server 2014
10 |1200 characters needed characters left characters exceeded

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

1 Answer

· Write an Answer
Jon Crawford avatar image
Jon Crawford answered

One would assume that the later version of SQLServer is performing more data checks, more functionality supported, different methods perhaps for doing those things. In order to then read the backup, it needs to log more information to support said functionality.

10 |1200 characters needed characters left characters exceeded

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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