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.


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