Compress SQL Server Back up file

What is the best way and fastest way to compress a SQL Server back up file with a good compression.
LegalZoomerAsked:
Who is Participating?
 
Steven_WCommented:
Alternatively, if you prefer not to use a third-party tool for backups, you could run a normal SQL Backup and then compress the resulting .bak file via a command-line tool such as GZIP, or WINRAR

(If your backups are done from a script, you can have the system run the compression striaght after the backup.

However, a tool such as LiteSpped (or http://www.red-gate.com/products/SQL_Backup/index.htm) will probably make this job a lot simpler.
0
 
dportasCommented:
Use a tool like LiteSpeed that will compress backups on-the-fly:
http://www.quest.com/litespeed-for-sql-server/

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.