Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How much extra disk space I need for sql backup?

Posted on 2016-11-17
7
Medium Priority
?
110 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 71

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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 71

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
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 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…

598 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