Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002

    Unanswered: Backup question: SQL 7.5 vs. SQL 2000

    Wondering if SQL 2000 offers any compression of logical backups vs. no software compression in SQL 7.5. I've been asked to evaluate a 3rd party tool that compresses SQL 7.5 backups nicely, but this tool does not allow concatenating all databases into a single logical device file. I'm thinking I won't recommend the tool if SQL 2000 does compression on the fly as we will be upgrading sometime over the next handful of months.


  2. #2
    Join Date
    Sep 2003
    what tool are you referring to? sqllitespeed? and why would you need to append to the device? so that when you really need it you can't find it or it became corrupt and you consequently cannot recover anything?

    sql2k does not compress, but m$ adopted sqllitespeed just for that purpose, as well as because it offers encryption (something that everybody is concerned about nowadays)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts