Page History
...
Each snapshot is a listing of permission settings on a SQL Server instance at a particular point in time. Snapshots help you assess and manage your security settings. This provides a powerful tool you can use to diagnose security problems and quickly see where changes occur.
The Snapshot Summary displays the following sections:
...
Baseline snapshots are snapshots that will not be deleted in the grooming process. To mark snapshots as baseline, you can right-click the snapshot and choose Mark as Baseline.
When a snapshot should be marked as baseline | Importance |
---|---|
When you take your first snapshot | To have a starting point to use to identify changes to permissions over time |
At the end of the month, quarter, or year | To track compliance to your database security policies |
When you implement a new security model | To identify unwanted changes or issues with the new model |
When you notice problems or irregularities in permission settings in a snapshot | To analyze the issue to correct problems and change permissions settings |
Tip | ||
---|---|---|
| ||
To view which snapshot is marked as baseline, click the respective SQL Server. The Audit History section of the Server Summary properties displays a list of all snapshots in this server where you can find a Baseline column that informs you which snapshot is marked as a baseline and which ones are not. |
...