How to use AOFO and protect 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:

  • The SQL user data and log files must exist on the mirrored volume (plex) in order for the snapshot to occur.

  • To protect system databases, the system database files must reside on the mirrored volume (plex).

More Information

About the Advanced Open File Option

Setting default options for the Advanced Open File Option

About SQL 2005 or later database snapshots

How to use AOFO and protect SQL on Windows 2000