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 developer central 1.9.—editor]
Mike Gunderloy, MCSE, MCSD, MCDBA, is a former MCP columnist and the author of numerous development books.