Update Instance (General)

Use to update an instance of Microsoft SQL Server Notification Services. You must disable the instance before updating it.

During an update, Notification Services compares the data in the instance configuration file (ICF) and application definition files (ADFs) with the metadata in the instance and application databases to determine what needs to be updated.

After Notification Services compares metadata, Microsoft SQL Server Management Studio displays an Update Summary dialog box showing the differences found between the databases and the files. Review the list before continuing with the update operation.

Warning

If the update operation fails before completion, the instance and application databases can be left in an inconsistent state, which means data will be lost. If the data is critical, back up the instance and application databases before updating the instance.

Options

  • Configuration file
    Use the Browse button to select the instance configuration file (ICF). This is an XML file that describes the instance and points to the application definition files (ADFs) that describe the applications hosted by the instance.
  • Parameters
    After you have selected the configuration file in the Configuration file box, the Parameters box lists all parameters (strings that start and end with %) found in the ICF. If a default value is found in the ParameterDefaults section, or if the parameter is an environment variable, the default values appear. You can override the default values by replacing the text in the Value column.

    If the ICF does not contain parameters, the Parameters box is empty and not enabled.

  • Enable instance after it is created
    Select this option to enable the instance after the update is complete.

    If you do not select this option, you can right-click the instance and select Enable or you can use the nscontrol enable command to enable the instance.

See Also

Reference

Notification Services F1 Help

Other Resources

Updating Instances and Applications
Using Parameters in an Instance Configuration File
nscontrol update Command
nscontrol enable Command

Help and Information

Getting SQL Server 2005 Assistance