January 30, 2004 at 9:33 am
Is there a way that MSSQL can compress a backup while it is dumping it or after it dumps?
January 30, 2004 at 1:39 pm
Well I'll probably get flamed, and I do not believe MS Supports it. But I do all of my backups into NTFS compressed directories.
I've done it for years, never had a problem.
You could probably write a job to Zip the DB up at the end of the backup. But I have had numerous problems restoring from backups that were sipped. And zip has some size limitations.
KlK
January 30, 2004 at 1:56 pm
"Is there a way that MSSQL can compress a backup while it is dumping it or after it dumps?"
No at all.
January 30, 2004 at 4:29 pm
No native way. 4 methods I know of.
1. Write a script to pkzip your .bak file.
2. Use SQL Litespeed (Allen's link above). We use that here at SSC and at my company. Rock solid.
3. BMC SQL Backtrack. Looked at a little, licensing didn't work for me. Might for you.
3. SQLZip - Tested by Andy Warren, ate up lots of resources, but worked well. Cheapest (other than your script).
February 3, 2004 at 3:02 pm
Veritas also has a SQL Server agent that compresses the backups...
Like kknudson, I have been backing up our databases to NTFS compressed directories for several years now and have never had any problems with either the backup or any restores.
See http://support.microsoft.com/default.aspx?scid=kb;en-us;231347&Product=sql2k for the official MS take on the issue. This simple technique has saved us a lot of grief and expense, but as usual, your mileage may vary...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply