August 4, 2003 at 1:13 pm
I am not able to zip a backup of 5gb, which needs to be restored in another server. What are my possibilities? thanks much
August 4, 2003 at 4:48 pm
Cant zip because? The latest revs of PKZip/Winzip support greater than 4g zip sizes. If you just dont have space to do it, you can just copy it across.
Andy
August 6, 2003 at 2:29 am
Hi
Try using WinRAR - an excellent tool which I have personally used a lot on database close to 10 Gb.
August 6, 2003 at 6:23 am
Use sqlzip to do the backup, it will compress the backup on the fly. A 5gb backup file will be around 400mb when done. Sqlzip is also faster on the backup and restore than the native sql backup utilities. Any way that has been my experience.
Bill Stevenson
MCSE, MCDBA
Bill Stevenson
MCSE, MCDBA
August 6, 2003 at 7:23 am
I'd recommend WinRAR as well. It can handle HUGE DB sizes. I compressed a 100GB database (no free space) down to 6 GB using the normal compression rate with WinRAR.
August 13, 2003 at 7:49 am
Another alternative is to use SQL LiteSpeed. It mimics the native SQL Server backup and restore commands, but allows you to compress your backups on the fly and also reduces the time it takes to backup the database.
To learn more about SQL LiteSpeed or to download and eval version you can go to:
http://www.edgewoodsolutions.com/litespeedeval.asp
Greg Robidoux
Edgewood Solutions
http://www.edgewoodsolutions.com
Greg Robidoux
Edgewood Solutions
www.edgewoodsolutions.com
August 14, 2003 at 2:49 am
Hi there
WinRAR rocks. I also use the free gzip.exe (try a search on our friend google.com). Its a simple command line util which ive wrappered a call to in my custom backup scripts like:
set @cmdline = @p_zippath + '\gzip.exe ' + @v_filename
EXEC @v_error = master..xp_cmdshell @cmdline, NO_OUTPUT
Email me if you cant find it.
I would prefer lightspeed, but my boss doesnt prefer the cost 🙂
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
August 14, 2003 at 4:44 am
Saw a recent article, PKZip and Winzip support different encryption methods now, so potentially a zip is not universably readable anymore - if you need to secure them.
Andy
August 14, 2003 at 7:03 am
WINRar - I've used it for several years for archiving databases. Very handy.
Dr. Peter Venkman: Generally you don't see that kind of behavior in a major appliance.
Patrick
Quand on parle du loup, on en voit la queue
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply