Share via


How to: Export Instance Metadata (SQL Server Management Studio)

In SQL Server 2005, you can export the instance and application metadata from the instance and application databases, creating new copies of the instance configuration file (ICF) and all application definition files (ADFs). The following procedure shows how to export the metadata to the SQL Server Management Studio editor.

Note

SQL Server Management Studio exports the metadata using current Microsoft Windows locale setting.

Important

If you use argument encryption, exporting instance metadata prompts for the encryption key and then decrypts the arguments and writes them to the resulting XML files.

To export metadata from the instance and application databases

  1. In Object Explorer, expand Notification Services.

  2. Right-click the instance of Notification Services, point to Tasks, and select Export to Editor.

    Notification Services will open one ICF and one ADF per application in the XML editor.

See Also

Reference

Microsoft.SqlServer.Management.Nmo.Instance.Export(System.String,System.Boolean)

Concepts

Exporting Notification Services Instance and Application Metadata

Other Resources

nscontrol export Command
Managing Instances and Applications How-to Topics (Notification Services)

Help and Information

Getting SQL Server 2005 Assistance