How to: Update One Application in a Multi-Application Instance (SQL Server Management Studio)

If you need to change any values in one application, but you do not need to update values in the instance configuration file or in other applications hosted by the instance, you can update just the application. Other applications in the instance can continue to run during the update.

Note that Notification Services reads the instance configuration file and other ADFs, compare the values to current values in the databases and then attempts to update anything that differs.

Note

If you update an event, subscription, or notification classes, the underlying tables are deleted and recreated.

Note

If you modify an operational file, you must restart the instance to load the modified 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 application

  1. Update the application's ADF.

    Note that if you update the instance configuration file, you must disable and update the entire instance.

  2. Back up the instance and application databases. For more information, see Backing Up and Restoring Databases in SQL Server.

  3. In Object Explorer, open the Notification Services folder.

  4. Right-click the instance and select Properties.

  5. In the left pane, select Applications.

  6. In the Application box, select the application you are updating.

  7. In the Components box, clear the check box for each component of the application and then click OK to apply the changes. You can clear all check boxes by clearing the Application box.

  8. Right-click the instance, point to Tasks, and then select Update.

  9. In the Update Instance dialog box, click Browse and select the updated ICF.

  10. Enter or update values as necessary for any parameters shown in the Parameters box.

  11. If the instance uses argument encryption, click Encryption in the left pane and then enter the encryption key.

  12. Click OK to perform the update.

  13. Right-click the instance and select Properties.

  14. In the left pane, select Applications.

  15. In the Application box, select the application you are updating.

  16. In the Components box, select the check box for each component of the application and then click OK to apply the changes.

See Also

Tasks

How to: Update One Application in a Multi-Application Instance (Command Prompt)

Other Resources

Updating Instances and Applications
Managing Instances and Applications How-to Topics (Notification Services)

Help and Information

Getting SQL Server 2005 Assistance