December 3, 2007 at 4:56 am
hi.
i'm quite new to SQL and i need to compress some backup files generated from sqlagent. pls does anyone have an idea how i could do this?
thanks in advance
------------------------------------------------------------------------
All it takes, is a step in the right direction, your feet will manage to find the way. I didn't say it'll be easy!!![font="Comic Sans MS"]:cool:[/font]
December 3, 2007 at 5:14 am
SQL Server 2005 native backup can't compress the backup files, but there are several third-party solutions like SQL Litespeed, RedGate SQL Backup or SQLZip.
Alternatively you could call an utility like Winzip form a stored procedure to compress the files after the backup process has finished. Disadvantage of this method is that the whole backup and restore process takes longer. Depending on the size of your databases this could mean that a restore might take longer than your SLA finds acceptable.
By the way SQL 2008 will support compression of backup files.
[font="Verdana"]Markus Bohse[/font]
December 3, 2007 at 8:57 am
Markus has the best advice.
Can you not just send some backups to tape or another disk and then delete them? I typically only keep 1-2 backups on disk.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply