How to: Migrate Notification Services Instances to a Higher Edition (SQL Server Management Studio)

If you create an instance of Notification Services using a lower edition of Microsoft SQL Server 2005, such as Standard Edition, and later want to upgrade to a higher edition of SQL Server, such as Enterprise Edition, you must upgrade the instance of Notification Services to the higher edition. The following procedure shows how to migrate a Notification Services instance to a higher edition using SQL Server Management Studio.

ms143717.note(en-US,SQL.90).gifImportant:
Instances of Notification Services can be deployed in many different configurations. Use the following procedure as a guideline for developing and testing your own migration procedures.

  1. In SQL Server Management Studio Object Explorer, expand Notification Services.

  2. Right-click the instance and select Disable.

  3. Right-click the instance you are migrating and select Stop.

  4. Close SQL Server Management Studio and any other open applications.

  5. On each server where the instance of Notification Services is installed, use Setup to upgrade Notification Services to the higher edition.

  6. In SQL Server Management Studio Object Explorer, expand Notification Services.

  7. In Object Explorer, right-click the instance, point to Tasks, and then select Upgrade. This upgrades the edition and version numbers in the instance and application databases.

  8. Right-click the instance and select Update.

    Provide the requested information in the Update dialog.

    Make sure to select Enable instance after it is updated.

  9. Right-click the instance and select Start.

Community Additions

ADD
Show: