How to use AOFO and protect SQL on Windows 2000

Article:HOWTO24061  |  Created: 2010-01-01  |  Updated: 2011-06-15  |  Article URL http://www.symantec.com/docs/HOWTO24061
Article Type
How To

Product(s)

Subject


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).

See About the Advanced Open File Option

See Setting default options for the Advanced Open File Option

See About SQL 2005 or later database snapshots


Legacy ID



v12011213_be2010_adm


Article URL http://www.symantec.com/docs/HOWTO24061


Terms of use for this information are found in Legal Notices