Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How does SQL Server calculate the initial size of a (compressed) backup?

How does SQL Server calculate the initial size of a (compressed) backup?

user-image
Question added by Mohamed Ahmed Mansour , Technical Director & Implementation Head , United Quality Information Systems
Date Posted: 2017/03/05
Naved Ahmed
by Naved Ahmed , Project Manager / Team Lead , Dynamics Technology Solutions

For compressed backup SQL server take the 1/3 size of the database. That can be vary once than final size.

 

for more details following links might be helpfull:

https://blogs.msdn.microsoft.com/psssql/2011/08/11/how-compressed-is-your-backup/

 

https://blogs.msdn.microsoft.com/psssql/2011/08/11/how-compressed-is-your-backup/

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.