Versions Compared

Old Version 1

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 2

changes.mady.by.user Unknown User (6092aebacc7830006a5cfc58)

Saved on

Key

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

The The Schedule Snapshots window  section allows you to choose the best times to collect data from your SQL Server instance. 

By default, snapshots are scheduled to run at midnight 3:00 am every Sunday morning (using the local time of the computer hosting the SQLsecure 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 selecting Take Snapshot from  from the context menu.

Info

SQL Secure requires that a user be logged in as the SQL Secure Administrator to view snapshot schedules.

...

 

To change the default 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

Click this button to edit your audit snapshot collection schedule specify .Specify the number of days that you want to store snapshots in the SQL Secure Repository.
Item
Description
Change
Keep snapshot for [number] days before allowing them to be groomed.Specify the number of days that you want to store snapshots in the SQL Secure Repository. Specify a number between 1 and 10000 days. By default, this value is set to 60 days.
Enable SchedulingSelect this option to enable the audit snapshot scheduleKeep snapshot for [number] days. If this option is disabled, you have to take snapshots manually.
ChangeClick this button to change the default snapshot collection schedule (3:00 am every Sunday morning). A new window opens where you can specify:
  • The schedule to be Daily, Weekly, or Monthly
  • The respective settings according to the type of schedule selected. For example if you choose Weekly, you can select which days of the week SQL Secure will collect the data and how frequently the schedule will run, for instance, every 1 or 2 weeks. 
  • The specific time of the day when the information will be collected, its frequency, and the Starting and Ending dates for this schedule option.

SQL Server Agent Status

Additionally, this section of the wizard allows you to see the status of your SQL Server Agent. Take into account that SQL Secure uses the SQL Server Agent for data collection and grooming. This Agent is located in the SQL Server hosting the Repository Database. You can see in this section whether the Agent status is Started or Stopped. 

Click Next to go to the following section to Configure your email notifications. 

View snapshot properties

To view the properties of a specific snapshot, go to the Explore Permissions view, expand the SQL Server from which the snapshot was taken, right-click the respective snapshot in the Snapshots window and then select Properties from , and select Properties from the context menu. To view a list . For more information about what properties you can see, go toView Snapshot Properties. 

In this same view, you can also see the list of snapshots and baselines for a specific SQL Server, select the Audit History tab on the Explore Permissions view.. To see this information select your required server from the Audited SQL Servers tree and SQL Secure displays an Audit History section on the respective Server Summary. For more information about this view, go to View single server summary. 

 

SQL Secure tells you who has access to what on your SQL Server databases. Learn more > >

...