Bayt.com

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?

Computer Science SQL Server 2000 2008
user-image
Question added by Mohamed Ahmed Mansour , Technical Director & Implementation Head , United Quality Information Systems
Date Posted: 2017/03/05
Upvote (0) Views (7) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
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/

Write Your Answer
More Questions Like This