Advanced backup management for SQL Server

Growing databases, shortening backup windows, and security concerns make backup and recovery management more complex than ever for today's SQL Server DBA. Embarcadero Backup Analyst for SQL Server solves these problems by offering advanced capabilities that cause backups to run dramatically faster and consume considerably less storage, with greater security.

The high performance backup and recovery engine contains powerful compression capabilities that reduce backup storage requirements by up to 80-90% in many cases. Encryption features offer extra protection for sensitive database backups, and the most complete backup and recovery management interface, which runs inside of DBArtisan administration console, make Backup Analyst for SQL Server the only choice for serious SQL Server DBAs who need an enterprise solution for their growing backup and recovery needs.

Better Security

Embarcadero Backup Analyst addresses two critical needs for backup and recovery. First, backups containing sensitive data are protected beyond the standard binary format used for backup files. This is an increasing common requirement of information privacy and security acts. Second, backup and recovery jobs run as expected so that the integrity and protection of a database is beyond doubt, and that the DBA is notified of any unexpected problem that occurs in essential backup or recovery tasks.

• Encryption can easily be applied to any backup task so sensitive data is safeguarded from all malicious or criminal intent.
• Specialized alert and notification capabilities instantly inform the DBA if any backup or recovery task doesn't complete as intended. All common notification mechanisms (email, page, etc.) are supported.
• Visual backup and recovery wizards guarantee that key tasks won't contain syntax errors that can result in invalid backup or recovery jobs.
• Backups can be further protected through use of backup file passwords.

Better Management

Managing the SQL Server offers DBAs powerful and flexible tools to craft a backup and recovery plan that is tailor made for your environment.

• Backup Analyst's visual interface keeps you fully informed at all times of backups and recoveries that are running, jobs that have failed, and databases in need of backup.
• Instant access to backup histories for all databases, filegroups, files, and transaction logs.
• Schedule backup and recovery jobs using Microsoft's Task Manager or the SQL Server Agent.
• Utilities set consistency checks and other inspections to be performed on all databases and associated objects.
• Powerful reporting capabilities provide well-formatted HTML reports that detail backup histories, databases in need of backup, recovery operations, and more.
• The command line interface allows all the capabilities of Backup Analyst to be used through standard SQL procedure calls. This allows Backup Analyst functionality to be embedded in any SQL script or third party backup software that supports SQL Server connectivity.

DBMS Support

• Microsoft SQL Server 2000, 2005 and 2008 System Requirements
• Windows® 2000, Windows 2003 (All editions), Windows 2003 R2 (All editions) and Windows XP (SP1 and SP2) and Windows Vista (Ultimate and Business) - 32-bit architecture only
• 512 MB memory
• 512 MB disk space
• DBMS Client connectivity utilities
• Internet Explorer 5.5 or later
• Power User or Administrator privilege required to run software