The Technical Services team for Backup and Recovery have produced a number of documents we call "Blueprints".
These Blueprints are designed to show backup and recovery challenges around specific technologies or functions and how Backup Exec solves these challenges.
Each Blueprint consists of:
The Need for Backup Solutions Designed for Microsoft SQL Server
Administrators responsible for the backup and recovery of SQL environments understand the challenges associated with backup technologies that are not specifically designed to protect SQL Servers. A modern and reliable backup and recovery strategy for Microsoft SQL Server provides an essential safeguard to help protect critical data that is stored in SQL Server databases.
There are three main objectives of performing SQL backups:
Administrators may be tempted to use the built-in SQL Server backup feature as their only method for protecting their SQL infrastructure. The built-in backup component is readily accessible and inexpensive. However, there are key limitations of the built-in SQL backup feature that make this a dangerous approach. It only backs up the SQL databases and not the entire server.
The Agent for Applications and Databases includes features and capabilities designed specifically to protect SQL environments and solve each of the problems listed above. The Agent for Applications and Databases enables network administrators to perform proper and intelligent backup and restore operations on installations of SQL that are connected to a network. Backup Exec™ 2014 incorporates online, non-disruptive SQL database protection as part of everyday backup routines, which increases the chance of data recovery and minimizes data loss without inhibiting daily database activity.
The Agent for Applications and Databases performs SQL database backups that can be integrated with network backups without separate administration or dedicated hardware. When using the Agent for Application and Databases to protect Microsoft SQL Server, administrators have the flexibility of the following capabilities:
You can download the full Blueprint from the link below.