Solved

How much extra disk space I need for sql backup?

Posted on 2016-11-17
7
75 Views
Last Modified: 2016-11-18
Hi

I am wondering how much extra disk storage I need to backup (sql database)

Is there any formula?

For example
My SQL data base size is 1.3tb

How much extra disk space I need to backup 1.3tb of data?

For example
0
Comment
Question by:michalek19
7 Comments
 
LVL 2

Expert Comment

by:Frans Brouwer
ID: 41892148
depends on the version SQL Server - SQL 2012 supports compression which is 2:1
0
 
LVL 68

Expert Comment

by:Qlemo
ID: 41892172
Without compression the backup file size is exactly the used database file size. So if your DB file is half used, the backup size is also half of the 1.3 TB = 650 GB.
0
 
LVL 4

Accepted Solution

by:
Daniel Jones earned 500 total points
ID: 41892458
Storage size depends on the number of revisions you want to store of your SQL data.  Each backup is a complete backup of the entire SQL database and log files.  This data is compressed, so take the number of revisions times the size of the SQL Data and divide by 2 to get a rough estimate of the total storage that you should have available to store backups.
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 7

Expert Comment

by:Jason clark
ID: 41892487
The Ratio is near about 1:3. This also depend which SQL Server version you are using.
0
 
LVL 16

Expert Comment

by:Gerald Connolly
ID: 41892855
I find this question and answer a bit worrying!

Yes its easy to calculate the disk space required for backups, but how does that help if the building burns down, gets flooded etc?

Business continuance anyone?
0
 
LVL 68

Expert Comment

by:Qlemo
ID: 41892928
Gerald, that was not the question, and nothing here indicates that the backup is on the same disk/media/location/office/cloud.
0
 
LVL 16

Expert Comment

by:Gerald Connolly
ID: 41893902
Qlemo, and there is nothing to say it isnt on the same ...

These two statements from the OP state the backup is to disk! Its not a big leap to assume they are either online or stored in the same room as the computer!

    I am wondering how much extra disk storage I need to backup (sql database)
and
    How much extra disk space I need to backup 1.3tb of data?

We see far too many requests on EE for help, where the requestor does not have any backups, or their backups are failing through the lack of some basic Business Continuity planning
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now