Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 132
  • Last Modified:

How much extra disk space I need for sql backup?

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
michalek19
Asked:
michalek19
1 Solution
 
Frans BrouwerSenior Systems AdministratorCommented:
depends on the version SQL Server - SQL 2012 supports compression which is 2:1
0
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
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
 
Daniel JonesData Research AnalystCommented:
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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Jason clarkDBA FreelancerCommented:
The Ratio is near about 1:3. This also depend which SQL Server version you are using.
0
 
Gerald ConnollyCommented:
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
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Gerald, that was not the question, and nothing here indicates that the backup is on the same disk/media/location/office/cloud.
0
 
Gerald ConnollyCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now