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
In Object Explorer, expand Notification Services.
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)