LiteSpeed Eases Database Tasks

Edgewood Solutions LLC is aiming to make backup and recovery of Microsoft Corp.'s SQL Server databases fast and painless.

Edgewood Solutions LLC is aiming to make backup and recovery of Microsoft Corp.s SQL Server databases fast and painless with SQL LiteSpeed 3, the latest version of its database backup tool.

SQL LiteSpeed 3, which the company released earlier this month, features a data compression and encryption engine fronted by a graphical console that offers guided backup and recovery. The software will support 64-bit computing as well as the next version of SQL Server, code-named Yukon. It is also compliant with Windows 2003 and Microsofts .Net.

The upgrades compression yields storage savings of 50 to 95 percent for SQL Server backups, according to officials at the Merrimack, N.H., company. The officials also said SQL LiteSpeed 3 hastens backup times by 50 to 75 percent.

The upgrade features improved job management, with advanced job scheduling, a detailed history of jobs, and the ability to check the integrity of databases and database tables.

Harv Sidhu, a vice president who manages the SQL Server group for Merrill Lynch & Co., in Hopewell, N.J., said the upgrades assisted recovery, wherein SQL LiteSpeed 3 recommends files that require backing up, will be helpful.

Sidhus group is using the tool for database backup that involves moving hundreds of gigabytes of data—a task that probably couldnt have been done before his group started using the product two years ago, Sidhu said. SQL LiteSpeed makes the data movement possible with its ability to perform compressed backups, reducing the time it takes to restore those compressed backups, and because of its small footprint, he said.

"Thats really saving our skin at the moment," Sidhu said. "The backup file sizes would have been much bigger [before using the product]. It takes longer to do those backups, and when you copy from one server to the next, it takes that much longer. And it takes longer to restore them. SQL LiteSpeed is cutting through all of that. We can do things in minutes or hours that would have taken us hours and days. I dont know how we would have survived without this, actually."