700 GB Database

Hot Topic

Connectivity issue
Report Builder Matrix
BACKUP LOG cannot be performed because there is no current database backup.
surface area configuration
Measures data disappeared suddendly
Report Run from a list instead of all
select * from sys.fulltext_languages
Expression-based Data Source + subscription = No-go?
SMART Goals
Interpreting the percentage in decision-tree model

SQL Server

How to Assign Identity Key values in Replication
Textbox color expression referring to textbox value
Connect to SQL Server from ASP.Net application
compilation error
BI tools from MS?
Simple error question?
JAVA and Stored Procedures
after moving tempdb SQL Server 2005 won't start
another n00b question
How can i cluster sql 2005 for load balancing?

700 GB Database

1. I have an issue regarding backup in Microsoft SQL SERVER 2000. I have a database with 700GB size. What could be the best solution(s) for backup.
2. I have 72 GB tape storage device, if I start the same 700 GB backupon 72GB tape device, will it be ask for the next tape after completingone 72GB tape, till 700GB.
3. Tape backup will make slow the transaction



Answer this question

700 GB Database

  • Eissing

    While there is a significant difference in the time it takes to backup due to writing significantly less into the backup because of compression, I've found ZERO different in restore speeds across more than 5000 different databases. (It would be bad if the restore performance degraded.)

  • Nerick

    Another couple of points to consider here:

    1. SQL Backup only copies the extents that are actually allocated. So, if you have a 700GB database that is 50% full, the backup will be ~350GB, not 700GB.
    2. All current tape hardware that I am aware of does hardware-based compression on the drive. So, that 350GB would typically take up far less space on tape than it would seem. If you're going direct to tape, I'd suggest trying it out and seeing how many tapes it actually takes.
    3. Doing backup to disk (possibly compressed using a 3rd-party product such as LiteSpeed) gives you the advantages of faster backup speeds, and significantly faster restore speeds. As has been pointed out, disk storage can be obtained at a very reasonable price these days.


  • GrandpaB

    I recommend that you configure your database to use filegroups so you can create filegroup backups. For an understanding of implementing filegroups, checkout http://www.informit.com/guides/content.asp g=sqlserver&seqNum=42&rl=1

  • Thase

    Check out SQL Lightspeed.

  • suryany

    I'm going to be setting up a server which will have a pretty large database - I'm thinking it might end up being 700GB. I was currious what the specs of the hardware you were running it on were Any help would be appreciated. thanks.

  • ShimonSim

    That is hard to say.

    1. What are your recoverability requirements

    2. How volitile is the data

    3. What hardware is available for backups

    Those are for starters.



  • twospoons

    Just a suggestion

    For about $700 US you can buy a 1000GB external HDD

    That run on USB 2.0 480 Mbits per second

    Check it out at the following address

    http://www.lacie.com/products/product.htm pid=10128



  • 700 GB Database
Answer this question