Export (0) Print
Expand All
Expand Minimize

How to: Update an Instance of Notification Services (Command Prompt)

SQL Server 2005

To update the instance configuration file or to update an application in a single-application instance, you can disable the entire instance and then perform an update.

ms172591.note(en-US,SQL.90).gifNote:
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.

ms172591.note(en-US,SQL.90).gifNote:
If you update an XSLT file, you must restart the instance so that Notification Services will load the updated file.

ms172591.note(en-US,SQL.90).gifNote:
The following procedure assumes you are configuring the instance of Notification Services by 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.

  1. Update the instance configuration and application definition. Also, perform any necessary updates to operational files, such as XSL transforms (XSLTs), at this time.

  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 Programs\Microsoft SQL Server\Notification Services, and then click Notification Services Command Prompt to open a command prompt window.

  4. Type the following command to disable the application:

    nscontrol disable -name instanceName

    If you are 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 -in configFile

    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 -name instanceName

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

Community Additions

ADD
Show:
© 2015 Microsoft