Symantec Backup Exec 2010 AGT MS SQL 20052563 Leaflet
Product codes
20052563
Symantec Backup Exec™ 2010
Copyright © 2009 Symantec Corporation. All rights reserved. Symantec and the Symantec logo are trademarks of Symantec Corporation. All other brands and
products are trademarks of their respective holder/s. 1/2010
products are trademarks of their respective holder/s. 1/2010
Microsoft SQL Database Protection
Microsoft SQL database backup and recovery is an inherently challenging process that becomes more
difficult as a company’s SQL database grows and the demands on its online availability increases,
further limiting the time available for backup and recovery operations. Many organizations use
manual backups to protect their SQL data. However, these methods do not provide the reliability
required by corporate environments or improve the availability of critical systems.
Eliminating backup overhead on production databases is a requirement for many of today’s critical
online business applications. As SQL data continues to grow in today’s enterprise, so does the
demand placed on an organization’s ability to protect the database in an online state, and overall
reduce the IT risk exposure to the database and the applications that rely on it. Without reliable data
protection in place, the slightest performance impact or downtime to a SQL environment can result in
significant business loss. An efficient backup and recovery solution is required to eliminate downtime
and provide complete data protection for critical SQL environments.
Today’s SQL database protection challenges include:
difficult as a company’s SQL database grows and the demands on its online availability increases,
further limiting the time available for backup and recovery operations. Many organizations use
manual backups to protect their SQL data. However, these methods do not provide the reliability
required by corporate environments or improve the availability of critical systems.
Eliminating backup overhead on production databases is a requirement for many of today’s critical
online business applications. As SQL data continues to grow in today’s enterprise, so does the
demand placed on an organization’s ability to protect the database in an online state, and overall
reduce the IT risk exposure to the database and the applications that rely on it. Without reliable data
protection in place, the slightest performance impact or downtime to a SQL environment can result in
significant business loss. An efficient backup and recovery solution is required to eliminate downtime
and provide complete data protection for critical SQL environments.
Today’s SQL database protection challenges include:
Protecting the database in an online state while minimizing impact during backup windows
Restoring the database to a point in time that exists between backup sets
Maintaining rigid service level agreements for both backup and recovery operations
Setting the Standard in Microsoft Database Protection
Symantec Backup Exec 2010 Agent for Microsoft SQL Server protects business-critical online
transaction processing (OLTP) and e-business data in case of application or hardware-based
corruption or loss. Designed to be flexible and easy to use, this agent gives SQL Server 2000, 2005,
and 2008 users’ comprehensive and customizable protection down to the individual file group.
Backup Exec 2010 leverages the capabilities and technologies in Microsoft SQL Server to provide
complete protection of the SQL database components including:
transaction processing (OLTP) and e-business data in case of application or hardware-based
corruption or loss. Designed to be flexible and easy to use, this agent gives SQL Server 2000, 2005,
and 2008 users’ comprehensive and customizable protection down to the individual file group.
Backup Exec 2010 leverages the capabilities and technologies in Microsoft SQL Server to provide
complete protection of the SQL database components including:
Data recovery to named transaction log marks within the transaction log, so administrators
can restore data up to the point at which the data was last committed to the database
can restore data up to the point at which the data was last committed to the database
Modeling of SQL database backups that can be targeted to fit the individual needs of the
business by performing full or differential backups and restores of the file group
business by performing full or differential backups and restores of the file group
Expanded data protection parameters that include multiple and named SQL Server
2000/2005/2008 database instances running concurrently on the same server
2000/2005/2008 database instances running concurrently on the same server
Improved performance of database consistency checks (DBCC) with the ability to perform a
physical-only DBCC on SQL Server 2000/2005/2008 databases, which greatly enhances
backup speeds without sacrificing backup accuracy
physical-only DBCC on SQL Server 2000/2005/2008 databases, which greatly enhances
backup speeds without sacrificing backup accuracy
Support for SQL Server database mirror data protection
Support for SQL 2008 Filestream Data (BLOB) including Word documents, spreadsheets, pictures, etc.
Support for SQL 2008 Database Compression which reduces volume of data that SQL sends to Backup Exec
Figure 1: view of Microsoft SQL Server backup configuration
Platform Support
Microsoft Windows Server
2008 Family (including
32-bit, x64 and R2
versions)
32-bit, x64 and R2
versions)
Microsoft Windows Server
2003 Family (including
32-bit, x64, and R2
versions)
32-bit, x64, and R2
versions)
Microsoft SBS 2008
Microsoft SBS 2003
Family (including R2)
Microsoft Windows 2000
Server Family (SP4)
Key Business Benefits
Non-disruptive SQL server
backup and quick
restoration
restoration
Support for both 32 and
64-bit SQL Server
installations
installations
Integrity of vital SQL
Server data is maintained
during backup and
recovery operations
during backup and
recovery operations
Increases the chance of
data recovery and
minimizes data loss
without inhibiting daily
database activity
minimizes data loss
without inhibiting daily
database activity
Point in time database
recovery allows for quick
database restore
database restore