Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    Unanswered: Any experience with SQLLITE

    Anyone has ever used the new 'SQLLITE' tool? Looks like it reduces the backup time and size by almost 70%. Any feedback?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Yup, was tasked with it, and tested the living heck out of it. The maximum database size I tested it with was 400G, - the resulting backup size with no compression was 82G vs. native backup - 381G.

    Also wrote a wrapper that would take all possible parameters that SQLLiteSpeed supports and produce filenames for backup devices that are similar to the ones produced by SQLMAINT utility.

    What else would you like to know? Oh, they also are coming up with a GUI for it, so that you can restore just like in EM.

  3. #3
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185
    So your 400 GB DB was compressed to 82 GB? That's a good ratio, any improvement with backup and restore time?
    Also have you noticed any performance degradation on your box running the SQL Server?

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    I didn't retain time statistics, our convern was the space constraints, but I know that it was taking less than native. As for performance, - it is CPU-intensive, on both backup and restore. But if you're using default compression and no encryption, - it may max out 2 out of 4 CPU's for short periods of time.

Posting Permissions

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