Using snapshot technology with the SQL Agent

The SQL Agent supports snapshot technology for SQL 2000 and SQL 2005 through the use of the Symantec Backup Exec for Windows Servers - Advanced Open File Option (AOFO) and the Advanced Disk-based Backup Option (ADBO). ADBO can only be installed on Windows Server 2003/2008. The use of ADBO and AOFO can reduce both restore time and backup impact on the server.

Note:

The SQL Agent also supports SQL 2005 database snapshot technology.

Before you use snapshot technology with the SQL Agent, review the following information:

More Information

About SQL 2005/SQL 2008 database snapshots

Consistency checks for SQL

Setting backup options for SQL