3

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?

1
  • There isn't a question in here. As such, I would reword it, or face getting your question closed. Sep 9, 2011 at 16:13

3 Answers 3

2

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/

2
  • 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? Sep 9, 2011 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. Sep 11, 2011 at 20:15
2

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).

1
1

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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