Database Backup compression

  • What is the best way to compress and maintain the SQL Server Database backups?

    Will that not affect the backup file?

    What is the best tool in the market for database backcup compression?

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

  • There are great tools available, like SQL LiteSpeed, to compress the backups. When you use one of these utilities, the file can only be restored by using the same utility. LiteSpeed comes with a command line tool to convert the backup file back to a native file if you need to. I don't know what the best tool is.

    I have used SQL LiteSpeed extensively in my environment for two years. I did a review of RedGate's product SQL Backup yesterday, which I also liked, but only tried out for the review. Both of these products can be downloaded for an evaluation from their websites.

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

  • SQL native backups are ineffecint.

    I have also tried red gate backcup. it was ok with me.




    My Blog: http://dineshasanka.spaces.live.com/

  • I am using a tool to compress my DB's and to store it to other node in the network.It zip the database according to the ratio specified.It will not affect the existing back up as ihave restored the Back up DB and tested.

    It is a freeware tool too.The following lik will reach you to the place. 

    http://www.2brightsparks.com/freeware/freeware-hub.html

  • You may evern want to try out SQL Backtrack for SQL Server from BMC. It also has a compression utility available. http://www.bmc.com

  • I use Backup Analyst from Embarcadero - it runs within my DBArtisan admin tool.  Easy to use and cheap - only $129 per server.

  • Idera also has a tool that I'm demo-ing, SQLsafe. It also encrypts and the price is right.


    Terry

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply