?
Solved

How much extra disk space I need for sql backup?

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

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
7 Extremely Useful Linux Commands for Beginners

Just getting started with Linux? Here's a quick start guide that has 7 commands that we believe will come in handy.

 
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 70

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
Many businesses neglect disaster recovery and treat it as an after-thought. I can tell you first hand that data will be lost, hard drives die, servers will be hacked, and careless (or malicious) employees can ruin your data.
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…

800 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