Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2009-04-28 : 16:04:32
|
| I know there are tools that squeeze SQL backup on the air. And I know SQL 2008 has the backup compression built in. But I am looking for a way to force SQL server 2k5 to produce smaller SQL backups or compressed backups? Is there a coding approach?Canada DBA |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-04-28 : 16:14:02
|
| You can compress the backup file afterwards using WinZip, WinRar, or 7zip. You get better compression ratios than with SQL LiteSpeed, Red Gate or the native 2008 compression, but it costs you a lot of time (for large backups anyway). If you want to roll your own, you need to get some technical documentation from Microsoft on how to write virtual device handlers and write your own extended procedures. Better to get one of the commercial tools instead, last I remember Red Gate was $200-$300 per server. |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2009-04-29 : 08:52:28
|
| I'm aware of all this Rob. But actually, the reason I posted this is that I want to start a challenging work to write some codes to create smaller BAK files. No matter what ratio. I just want to make some level of compression. May be some want to help and we can do this all together. There are tools on the market more efficient and not so expensive but I want to challenge. :)Canada DBA |
|
|
|
|
|
|
Backup Compression