Idera's SQLsafe brings compression, encryption, ease, and speed to backups of Microsoft's database
Idera’s SQLsafe — a backup utility for Microsoft SQL Server — was designed to compete directly with Imceda’s LiteSpeed. Similar to LiteSpeed, SQLsafe improves on native SQL Server backups with compression, encryption, faster backups and restores, and lots of extras that make managing database backups easier.
For example, SQLsafe offers different backup compression rates so that DBAs can choose what’s more important to them, speed or size. (In my early tests, using the highest compression setting, I achieved 71 percent compression.) And SQLsafe can encrypt backups using AES, DES, Triple-DES, or RC2 algorithms, giving admins a lot of flexibility in securing off-site data.
One feature I really like is the ROI calculator, which allows you to easily estimate storage costs as your data volume grows. SQLsafe’s default cost assumption is $200 per gigabyte, but you can enter whatever amount is appropriate for your environment. Another useful feature is the compression calculator, which tells you how much storage space you’ll need for different compression rates.
SQLsafe’s GUI is very intuitive, making it easy to get status on current backups (queued, processing, error, complete, failed, cancelled) and also view statistical information such as how many backups completed and how many failed in the past week. And, using SQLsafe’s CLI, you can script entire backup scenarios that are as complicated as your scripting language allows. Using preprocess and post-process switches, I was able to define scripts that ran both before and after my backup.
SQLsafe is a promising way to manage SQL Server backups and a worthy competitor to LiteSpeed. Which to choose? Ask me after I try the new version of LiteSpeed in the coming weeks.
Idera SQLsafe 1.1
Cost: $995 per server
The transition from command line to line-of-command requires a new mind-set -- and a thick skin
Siri gets smarter. Apple Watch gets much more useful. And is Apple Music poised to kill other streaming...
People who have it don’t want it. People who want it don’t have it. Here's how to go from iconed to...
The Web's security runs on complicated PKI deployments, few of which are implemented correctly, and all...
Solid new version of Windows 10 Insider Preview makes it look likely that Microsoft will indeed hit RTM...
Package ecosystem and graphics are strengths; security and memory management are weaknesses
Self-checkout comes to the food court, with the same mixed experience as at any self-checkout terminal ...