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.

Featured

  • Vendors Issue Patches for Linux Container Runtime Flaw Enabling Host Attacks

    This week, the National Institute of Standards and Technology (NIST) described a high-risk security vulnerability (CVE-2019-5736) for organizations using containers that could lead to compromised host systems.

  • Windows 10 Version 1809 Users May Get Visual Studio Crashes

    Microsoft on Friday issued an advisory for Windows 10 version 1809 users about possible Visual Studio crashes.

  • Standardizing the Look of Outlook's Outbound Messages

    Microsoft typically gives users a blank canvas to compose new e-mails in Outlook. In some corporate environments, however, a blank canvas isn't a good thing.

  • Windows 10 'Semiannual Channel Targeted' Goes Away This Spring

    Microsoft plans to slightly alter its Windows servicing lingo and management behavior with its next Windows 10 operating system feature update release, coming this spring.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.