View the protection status of SQL Server assets
You can view the policies or protection plans that are used to protect instances, availability groups, or intelligent groups.
To view the protection status of SQL Server assets
- Select one of the following tabs: Instances, Availability groups, Databases, or Intelligent groups.
- For instances, availability groups, or databases, the Protected by column indicates how the asset is protected. See Table: Protection status of SQL Server databases, instances, or availability groups. For intelligent groups, the Protected by policy column indicates if an intelligent group is included in a policy.
Table: Protection status of SQL Server databases, instances, or availability groups
Protection type or status | "Protected by" value | |
|---|---|---|
Database | Instance or availability group | |
A classic policy protects the asset. | Classic policy | Not protected Go to to see how classic policies are used to protect instances or availability groups. |
A protection plan protects the asset. | Protected | Protected |
Neither a plan nor a policy protects the asset. | Not protected | Not protected |
A policy or a protection plan protects the asset, but it is not backed up yet (no backup image exists). | Not protected Protected by column is blank. | Not protected |