Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I noticed that simply zipping my backup files reduces the space used by 70%

My idea was to, initially, backup the databases to a local server; then, using Bacula or Cobian (I don't have a budget), compress it and then ship it to our remote SAN.

Did you face similar challenge? If so, how did you overcame it?

share|improve this question
    
There isn't a question in here. As such, I would reword it, or face getting your question closed. –  RateControl Sep 9 '11 at 16:13
add comment

3 Answers

There are commercial (Redgate for example) and free products that will do this for you as part of the backup.

http://sourceforge.net/projects/mssqlcompressed/

share|improve this answer
    
Nice shot, I will give it a try on our test server. Do you use it in production, or know anyone who has first-hand experience with it? –  Lynx Kepler Sep 9 '11 at 19:51
    
I don't have any clients using it in production but I use it myself on my laptop and test servers. As standard SQL backup formats are used, with standard compressions libraries injected into the process, it's essentially doing as you were going to do but automated. –  Mark Storey-Smith Sep 11 '11 at 20:15
add comment

Upgrade to

  • SQL Server 2008 Enterprise and higher or
  • SQL Server 2008 R2 Standard and higher

to get it natively.

Or use a 3rd party tools (as per Mark Storey-Smith's answer).

share|improve this answer
4  
I would add that backup compression in 2008 comes only with Enterprise edition. You need 2008 R2 for it to be available in Standard edition. –  Nick Chammas Sep 9 '11 at 18:07
add comment

Look at RedGate's HyperBac. It's a few hundred bucks a server and it is well worth the cost.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.