The Schedule Snapshots window allows you to choose the best times to collect data from your SQL Server instance.
By default, snapshots are scheduled to run at midnight every Sunday morning (using the local time of the computer hosting the SQL Secure Repository). The first snapshot is taken at the first scheduled snapshot collection time. You can manually take a snapshot at any time by right-clicking the SQL Server instance in the Explore Permissions view and then selecting Take Snapshot from the context menu.
SQL Secure requires that a user be logged in as the SQL Secure Administrator to view snapshot schedules.
The Schedule Snapshots window contains the data collection schedule that is currently being used for the SQL Server selected instance. To change the schedule, click Change and select the new time and frequency. When possible, schedule snapshots to run during non-peak or off-hour times.
Schedule Snapshots window actions
| Item | Description |
|---|---|
| Change | Click this button to edit your audit snapshot collection schedule. |
| Enable Scheduling | Select this option to specify the audit snapshot schedule. |
| Keep snapshot for [number] days | Specify the number of days that you want to store snapshots in the SQL Secure Repository. |
View snapshot properties
To view the properties of a specific snapshot, right-click the snapshot in the Snapshots window and then select Properties from the context menu.
To view a list of snapshots and baselines for a specific SQL Server, select the Audit History tab on the Explore Permissions view.