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

  • Microsoft Expands Azure AD Password Lengths, Adds Conditional Access Controls

    Microsoft announced a couple of Azure Active Directory enhancements this week regarding password lengths and new conditional access controls for IT pros.

  • Attack Surface Analyzer 2.0 Available for Checking Software Installs

    Microsoft this week described Attack Surface Analyzer 2.0, an updated tool for checking software installations that's now built using open source code.

  • What Causes Hyper-V Replication Failures?

    Hyper-V replication failures happen rarely, but their impact can be catastrophic when they do. Know the scenarios that are likely to trigger a replication failure.

  • Microsoft Touts Using HyperClear To Address Intel Processor Woes

    Microsoft is again promoting its HyperClear Hyper-V hypervisor technology as a potential balm for organizations trying to come to grips with Intel's latest speculative execution side-channel attack disclosures.

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.