Remove protection from SQL Server assets
You can unsubscribe databases, instances, or availability groups from a protection plan. When the asset is unsubscribed, backups are no longer performed.
Note:
When you unsubscribe an asset from a protection plan, there is a possibility that the asset displays in the web UI. This situation can happen when an asset is subscribed to a protection plan and a backup runs for that asset. Then the asset is unsubscribed from the protection plan while it has a valid backup image. The web UI displays , but there may or may not be an active policy protecting the asset.
To remove protection from an instance
- On the left, click Microsoft SQL Server.
- Select the asset that you want to unsubscribe.
Remove protection from an instance
On the Instances tab, click on the instance that you want to edit.
Remove protection from a database
On the Databases tab, click on the database that you want to edit.
Remove protection from an availability group
On the Availability groups tab, click on the availability group that you want to edit.
Remove protection from an availability database
On the Databases tab, click on the database that you want to edit.
- Click Remove protection > Yes.
The asset is listed as Not protected.