Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 baselineImportance
When you take your first snapshotTo have a starting point to use to identify changes to permissions over time
At the end of the month, quarter, or yearTo track compliance to your database security policies
When you implement a new security modelTo identify unwanted changes or issues with the new model
When you notice problems or irregularities in permission settings in a snapshotTo analyze the issue to correct problems and change permissions settings
Tip
titleViewing which snapshot is marked as baseline

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.  

...