mardi 27 janvier 2015

Backup compression in SQL server 2008R2 and above


Recently we got a new server to take care of and found that there are two data drive:


S: 1 TB where resides 10 databases(mdfs and ldf's, though they should be on different drives but that's how we got the set up) where max size of a DB being 780 GB and rest pretty small.


X: similar scenario here as well a DB of 720 GB resides rest small and bits, total of 10 DB's


Now, we've been asked to perform the backup strategy and for that i am sure we are short of backup drive as there does not exist any other drives apart from C: and above two.


Since this being sql server 2008R2 enterprise, Compression feature has been enabled and we are good to take compressed backups:


But my question here would be how can i predict or calculate what size of drive would be require to accommodate the backups, means using the compression feature how can i predict close to the amount of disk space required to backup these 20 user databases.





Aucun commentaire:

Enregistrer un commentaire