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

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

Note that Notification Services reads the ICF and other ADFs, compares 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 by using an 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 ICF, 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. On the Start menu, point to All Programs\Microsoft SQL Server 2005\Configuration Tools, and then click Notification Services Command Prompt to open a command prompt window.

  4. Type the following command to disable the application:

    nscontrol disable -nameinstanceName-applicationapplicationName

    If using SQL Server Authentication, your nscontrol disable command requires additional parameters. For more information, see nscontrol disable Command.

  5. Type the following command to apply the changes made in the ADF:

    nscontrol update -inconfigFile

    If the instance or application uses command-line parameters or SQL Server Authentication, your nscontrol update command requires additional parameters. For more information, see nscontrol update Command.

  6. From a command prompt, type the following command to enable the application:

    nscontrol enable -nameinstanceName-applicationapplicationName

    When you use SQL Server Authentication, your nscontrol enable command requires additional parameters. For more information, see nscontrol enable Command.

See Also

Tasks

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

Other Resources

Updating Instances and Applications
nscontrol disable Command
nscontrol update Command
nscontrol enable Command
Managing Instances and Applications How-to Topics (Notification Services)

Help and Information

Getting SQL Server 2005 Assistance