Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How much extra disk space I need for sql backup?

Posted on 2016-11-17
7
Medium Priority
?
117 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 72

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 2000 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 10

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 17

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 72

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 17

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Concerto Cloud Services, a provider of fully managed private, public and hybrid cloud solutions, announced today it was named to the 20 Coolest Cloud Infrastructure Vendors Of The 2017 Cloud  (http://www.concertocloud.com/about/in-the-news/2017/02/0…
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
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…

564 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