Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 892
  • Last Modified:

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.
0
LegalZoomer
Asked:
LegalZoomer
1 Solution
 
dportasCommented:
Use a tool like LiteSpeed that will compress backups on-the-fly:
http://www.quest.com/litespeed-for-sql-server/

0
 
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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now