Deleting Instances of Notification Services
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.
Deleting an instance is irreversible. To preserve instance and application data, back up your databases before deleting the instance.
How Instance and Application Data Is Deleted
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.
To delete an instance of Notification Services
- How to: Delete an Instance of Notification Services (SQL Server Management Studio)
- How to: Delete an Instance of Notification Services (Command Prompt)
- nscontrol delete Command
- Microsoft.SqlServer.Management.Nmo.Instance.Drop method
Manually Deleting Databases
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.
Unregistering an Instance of Notification Services
After deleting an instance, unregister the instance to remove registry entries, performance counters, and, if present, the Microsoft Windows service.
To unregister an instance of Notification Services
- How to: Unregister an Instance of Notification Services (SQL Server Management Studio)
- nscontrol unregister Command
- UnregisterLocal method