2

We have just solved the problem of stolen server by hiding an external backup unit in a different room of our office.

Now the problem is fire and all the other possilble disaster that can happen. We used to do an FTP upload of a password portected archive to an oversea server but the size of the backup is increased too much (bare metal recovery ~22GB) and it is not possible anymore. Most of the data is inside a MS SQL Server database (800MB).

What are the options we have to protect our data even in this case?

We don't have an high speed connection to any datacenter here and we are looking for a fully automated solution.

Thanks.

abenci
  • 503
  • 1
  • 7
  • 17
  • I'm not quite sure what's being asked here. Can you elaborate? – joeqwerty Sep 23 '10 at 22:16
  • I think they want to know a good way to backup data off-site. It gives a bit too much background, and not enough "This is what we want". Anyhow, What's the local machine running, how big is the backup, does it need to be overseas, or could it be to a local datacenter? – Sweet Sep 23 '10 at 23:25
  • That first sentence...ouch...maybe a "by" will help: "We have just solved the problem of stolen server [by] hiding an external backup unit in a different room of our office. – Mark Wagner Sep 23 '10 at 23:42
  • I have added the size of the backup we are currently doing and don't know how to estimate MS SQL Server database size (plain/compressed). – abenci Sep 24 '10 at 10:51

4 Answers4

1

How much of your database changes on a daily basis? We backup MS-SQL databases on 35 sites overnight via ADSL using BackupPC, which uses rsync to copy only the file differences. The way we do the backups is as follows:

1) At 9pm, a scheduled script on the Windows server dumps a copy of the database to a backup file. Databases range in size from about 4GB to 11GB

2) The database backup is split into 250MB sections using a free tool call Swiss File Knife.

3) BackupPC copies all the 250MB files to the backup server.

The splitting of the file into smaller part files allows BackupPC to totally skip copying the parts that have not changed since the last backup, and on the backup server itself only one copy of each identical part file has to be kept in the backup sets, although BackupPC makes each daily backup look complete by using hard links between each one to represent the files that have not changed overnight.

On sites with few daily changes, the backup takes around 30 minutes. On sites with slow ADSL lines (288K upload only) and a lot of changes, it takes about 4 hours, but it is totally automatic.

Linker3000
  • 668
  • 1
  • 5
  • 14
0

Get a fireproof safe and put it in your office. Place the USB HDD/tapes in this safe.

Also, consider taking backup media offsite as well. Fireproof safe at the bosses house too?

Imo
  • 841
  • 5
  • 7
  • Can you provide a link to these kind of products? Can the disk be connected while inside the save? Can water enter? Thanks. – abenci Sep 24 '10 at 10:57
  • I doubt there are safes that allow equipment to run inside them... if they exist they are probably expensive. The suggestion was made so that you would implement a backup strategy which included backing up to removable media and either taking it off site, and or, putting it in the safe. There are many different backup strategies and I'm sure a google search will help find suggestions. I searched "fireproof safe" in google products and heaps were listed. – Imo Sep 24 '10 at 11:58
  • Honestly we are looking for a fully automated solution. – abenci Sep 24 '10 at 12:15
0

Perhaps this could be useful:

Three external HDDs labeled Safe1, Safe2 and Safe3. Two external HDDs labeled Bank1 and Bank2.

At the end of each week, perform a full backup to one of the HDDs, and then, put it in a fireproof safe, located on site.

On the first week of the month, perform the backup on one of the disks labeled Bank and deposit it in a safe offsite location.

Use the media in a rotational pattern, swapping the disk at the bank every month and keeping a track of what data is stored where (what disk contains the most recent backup data).

Two disks in rotation are enough for onsite storage, but using three makes things simple - separate drive for three weeks between backups for bank deposit.

We use something very similar to this setup.

Hope it helps. Luke

blindluke
  • 1
  • 1
0

You didn't say whether it was the size of the upload that caused a problem with the FTP Upload you used to do, or the expected time to download it again in case of a Disaster Recovery situation?

If it's just the upload time, then you could significantly reduce this by using incremental SQL backups (which compress very well) after an initial full backup.

Will
  • 408
  • 3
  • 8
  • If you're not familiar with SQL Server's backups, there's a brief description of how to use differential backups here: http://netindonesia.net/blogs/ziglaret/archive/2008/05/20/backing-up-database-in-sql-server-2005.aspx – Will Sep 24 '10 at 13:54