How to: Update an Instance of Notification Services (SQL Server Management Studio)
If you need to update the instance configuration file or need to update the application in a single-application instance, you can disable the entire instance and then perform an update.
Note
If you update an event or notification classes, the underlying tables are deleted and recreated. If you update a subscription class, the underlying tables are renamed by appending Old to the table name.
Note
If you update an XSLT file, you must restart the instance so that Notification Services will load the updated file.
Note
The following procedure assumes you are configuring the instance of Notification Services using an instance configuration file (ICF) and application definition files (ADFs). If you are using Notification Services Management Objects (NMO), use methods of the Microsoft.SqlServer.Management.Nmo.Instance class to update the instance of Notification Services.
To update an instance of Notification Services
Update the instance configuration and application definition. Also, perform any necessary updates to operational files, such as XSL transforms (XSLTs), at this time.
Back up the instance and application databases. For more information, see Backing Up and Restoring Databases in SQL Server.
In Object Explorer, expand Notification Services.
Right-click the instance to update and then select Disable.
Right-click the instance, point to Tasks, and select Update.
In the Update Instance dialog box, click Browse and select the updated instance configuration file.
Enter or update values as necessary for any parameters shown in the Parameters box.
If the instance uses argument encryption, click Encryption in the left pane and then enter the encryption key.
Select the Enable instance after it is updated option to enable the instance at the end of the update process.
Click OK to perform the update.
See Also
Tasks
How to: Update an Instance of Notification Services (Command Prompt)
Other Resources
Updating Instances and Applications
Managing Instances and Applications How-to Topics (Notification Services)