Protecting SQL on Windows 2000

When you protect Windows 2000, the SQL Agent only supports the VERITAS Storage Foundation for Window FlashSnap Option.

In order to protect the SQL server using the FlashSnap Option, the SQL Agent, VERITAS Storage Foundation for Windows, and the Advanced Open File Option (AOFO) must be installed and running on the SQL server.

You can select the FlashSnap option through the Advanced Open File options dialog box. If Automatically select open file technology is selected on the Advanced Open File options dialog box when running Windows 2000, Backup Exec attempts to use the FlashSnap Option to perform the backup. If the FlashSnap option is not available, the job will fail. If you select the Symantec Volume Snapshot Provider or Microsoft Volume Shadow Copy Service options, a non-snapshot backup is performed.

Also, when using AOFO with FlashSnap note the following:

More Information

About the Advanced Open File Option

Setting defaults for the Advanced Open File Option for backup jobs

About SQL 2005/SQL 2008 database snapshots