Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Deleting Instances of Notification Services

SQL Server 2005

Deleting an instance of Notification Services deletes the instance and application data and removes Notification Services instance metadata from the instance of the Database Engine.

ms171349.note(en-US,SQL.90).gifImportant:
Deleting an instance is irreversible. To preserve instance and application data, back up your databases before deleting the instance.

When you delete an instance of Notification Services always deletes the instance and application data. Depending on the circumstances, deleting an instance of Notification Services might also delete the instance and application databases:

  • If Notification Services created the databases for instance or application data, deleting the instance also deletes the databases. Notification Services creates the databases if you specify new database names or no database names when defining applications and configuring the instance.
  • If you specified the names of existing databases for instance and application data when you configured the instance and defined the applications, Notification Services deletes all instance and application objects from the databases, with the exception of event chronicle tables and subscription chronicle tables.

For more information about defining the instance database, see Defining the Instance Database.

For more information about defining application databases, see Defining the Application Database.

If you manually delete databases that contain instance or application data, metadata about the instance still exists in the system databases. To remove the metadata from the system databases, delete the instance of Notification Services.

After deleting an instance, unregister the instance to remove registry entries, performance counters, and, if present, the Microsoft Windows service.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.