August 29, 2001 at 11:38 am
Should I remove the zipping and unzipping from my backup process?
Here is the proccess that we currently use to restore the production database on to the standby server:
Production server does a full database backup, then zips the backup file. Next the Standby Server copies the zip file to a local drive then unzips it and proceeds to restore it.
The database backup is 3 gigs before it is zipped and 700 megs after.
Both of these machines are Quad processeor Raid 10. The machines are both connected to the same network via multiple 100 mega bit net cards.
August 29, 2001 at 4:48 pm
The answer is - it depends! I normally advocate zipping files before copying in general, usually winds up being faster overall. Two things to consider, which is faster, and which can you better afford? Even if zipping is overall faster, if it puts a strain on your server that you cant support, you'll have to go with just copying the bak file.
Just to clarify, Im only supporting the zipping for when you need to go across the network, not for backups kept on the server.
Andy
August 31, 2001 at 11:50 am
Thanks for the info.
September 2, 2001 at 8:05 pm
Hi
This is a catch 22 really, space vs recovery speed, the recovery time increases because you now have to uncompress files, have you timed this? you may be supprised the minutes this can take so it may impact your SLA.
Cheers
Chris
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply