| # |
Feature |
Benefit |
| 1 |
Multiple compression and encryption methods |
Achieve optimal compression results and reduced backup and restore times.
The performance of the backup and the size of the output file vary greatly depending on the type of data being backed up. Different compression methods yield different results so having multiple compression methods is very important. Even better is the ability for the backup product to automatically select the best method based on the type of data it is backing up. |
| 2 |
Non-intrusive backup agent |
Achieves the performance and storage benefits of compressed backup without requiring operating system driver level changes to production servers or components to be installed inside SQL Server. |
| 3 |
Simple backup and restore wizards |
Provide for quick, easy execution of manual ad hoc backup and restore operations as well as generation of CLI/XSP scripts. |
| 4 |
Graphical point-in-time recovery |
Eliminates the complexity, and reduces time involved in performing a restore operation by automatically assembling the all the files in the correct sequence required to restore a database to a specified point in time. |
| 5 |
Real time monitoring of backup operations and browsing of backup history |
Quickly and easily monitor and browse current and historical backup and restore operations across tens or hundreds of servers. |
| 6 |
Object Level Recovery |
Quickly and easily recover a specific object without having to restore the whole database. |
| 7 |
Multiple Database Restore |
Quickly and easily restore multiple databases to enable rapid rebuild or migration of servers. |
| 8 |
Optional extended stored procedures (XSPs) |
Provide the choice of whether or not to use extended stored procedures to give the user the option of eliminating any potential risk caused by code running inside the SQL Server process. |
| 9 |
Integration with enterprise storage management environments |
Enables archiving and retrieval of SQL Server backups in enterprise storage management systems such as IBM’s Tivoli Storage Manager. |
| 10 |
Archive Grooming |
Perform automated backup file archive maintenance and grooming to enable efficient use of storage. |
| 11 |
Central repository of historical data |
Enables centralized real-time and historical status reporting, auditing, and storage of required backup metadata. |
| 12 |
Extensive platform support |
Complete coverage of operating system and SQL Server platforms in an environment. |
| 13 |
Conversion to native backup format |
Provide conversion from third-party format to native Microsoft backup format to enable transfer of backup data to other entities using standard Microsoft SQL Server backup and recovery features. |
| 14 |
Remote Backup Agent deployment, configuration and management |
Enables easy deployment, configuration and management of backup service across tens or hundreds of servers, significantly reducing the administrative load on the DBA. |
| 15 |
Comprehensive Reporting |
Enables quick, easy auditing and automated status reporting of backup and restore operations. |
| 16 |
Web-based Monitoring Console |
Enables secure, remote read-only monitoring and historical data browsing for DBAs and non-DBAs. |
| 17 |
Maintenance Plan Conversion |
Enables quick, easy conversion of existing native backup maintenance plans to the new backup product. |
| 18 |
Backup job automation |
Enables ‘hands-free’ backup via automated execution, monitoring and auditing of organizational backup policies. |
| 19 |
Flexible deployment architecture |
Allow the user to choose the deployment scenario they require. From a stand-alone compression/encryption agent to a complete backup and recovery solution. |
| 20 |
Simple, straightforward product pricing model |
Enables users to quickly determine the product features that are available and how much it costs without having to worry about different versions of the product. |