Product Reviews

SQLLiteSpeed

One of the problems that DBAs hit sooner or later is that backing up SQL Server databases can take a good long time. Although SQL Server backups are generally reliable, they can be inordinately time-consuming as your databases inexorably edge up towards the terabyte range. Many DBAs have resorted to partitioning or export schemes to reduce the backup load on the actual database.

SQLLiteSpeed is a new software package designed with one thing in mind: fast backups to disk of SQL Server 7.0 or 2000 databases. Implemented as a set of extended stored procedures with a syntax very similar to existing SQL Server backup commands, SQLLiteSpeed compacts data as it's being backed up. This means that backups take up less disk space, but more importantly (in many cases) it means that they can be completed sooner.

The product was designed to integrate with and improve on the base database product. It includes cluster support, instance support, actual 128-bit encryption for backup files (native backups contain all of your data in clear text), and less blocking of database operations that are going on at the same time as the backup. I could have really used this one when I was working with the giant online database a while back, where we did backups in the middle of the night and just prayed that not too many users would be affected. Data compression (on the order of 8 to 1 or better, depending on the data) is a nice bonus here as well, even given the negligible price of big hard drives these days.

You can download a 15-day trial version from the company's web site. Pricing starts at $495 and goes up depending on the size of your database.

[This review originally appeared in

About the Author

Mike Gunderloy, MCSE, MCSD, MCDBA, is a former MCP columnist and the author of numerous development books.

comments powered by Disqus
Upcoming Events

Redmond Tech Watch

Sign up for our newsletter.

I agree to this site's Privacy Policy.