var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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?
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.
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?
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.