Using the VSS Snapshot Scheduler wizard

You can use the VSS Snapshot Scheduler wizard to add a snapshot schedule.

The scheduling capability automates the process of refreshing snapshots sets. At the scheduled time for the snapshot, the snapshot volumes are automatically reattached, resynchronized, and then split again. Once configured and applied, the schedule is maintained by a scheduler service, VxSchedService.exe, that runs in the background. In a clustered server environment, ensure that the scheduler service is configured on each node with domain administrator privileges so that any node in the cluster can run the schedule after a failover.

Note:

To view the information about the operations that the schedule performs expand the appropriate application node to locate the schedules for that application, right-click the node, and select Job History.

The VSS Snapshot Scheduler wizard does not prepare the snapshot mirror. Prepare the snapshot mirror with the Prepare command before running the VSS Snapshot Scheduler wizard.

Note:

The Prepare command replaces the Snap Start command in the GUI.

To schedule a snapshot for a selected component

  1. From the VEA console, navigate to the system where the production volumes and snapshot mirrors are located.
  2. Expand the system node, the Storage Agent node, and the Applications node.

    If the Applications node is not shown, start the SQL Server VSS Writer service and then select the Storage Agent node and refresh the VEA display (Actions > Refresh).

  3. Expand the SQL node.
  4. Right-click the instance, and click Schedule VSS Snapshot.
  5. In the Welcome panel, review the information and click Next.
  6. Specify the snapshot set parameters as follows and then click Next:

    Select component for snapshot operation

    Select the database for the snapshot set.

    Directory

    The XML file is stored by default in the directory that is shown on the screen.

    In a clustered server environment, the XML file must be saved on shared storage to be available from all nodes in the cluster.

    There are two ways to change the XML file location.

    First, edit the directory path in the Directory field for this wizard screen. Second, change the XML file location. Use a text editor to create a text file named redirect.txt. This text file should contain a single text line specifying the Universal Naming Convention (UNC) path to the location of the XML file, for example, \\ServerName\SharedFolderName. Save the redirect.txt file in the default directory, for example: C:\Program Files\Veritas\Veritas Volume Manager\VSSXML.

    Snapshot set

    Enter a name for the snapshot set, for example, billing or accept the default name. The wizard generates a default snapshot set name that includes the term "SnapshotSet", component name, date, and time.

    The wizard creates the snapshot set metadata XML file with this name, with the prefix "VM_".

    Select snapshot type

    Select the snapshot type.

    You can specify that snapshots be created as either a Full backup or Copy backup type. Either type can be used to restore a database. However, if you want to replay the logs in SQL Server as part of restoring a database, a Full backup needs to have been created earlier. When replaying logs, you can replay from the time of the last Full backup. A Copy backup does not affect this sequence of log replay and therefore is often used as an "out of band" copy for purposes such as testing or data mining.

  7. In the Change Attributes panel, optionally change the attributes for the snapshot volumes and click Next:

    Volume Name

    Displays the name of the volume.

    Snapshot Volume Label

    Displays the read-only label for the snapshot volume.

    Drive Letter

    Optionally, click a drive letter and select a new choice from the drop-down menu.

    If the specified drive letters are not available when the snapshot is taken, the snapshot operation is performed, but no drive letters are assigned.

    Plex

    Optionally, click a plex and select a new choice from the drop-down menu.

  8. Optionally, in the Synchronized Snapshot panel (Volume Replicator only), select the secondary hosts for which you want to create synchronized snapshots. Either double-click on the host name or click the Add option to move the host into the Selected Secondary Hosts pane. To select all the available hosts, click the Add All option. The VSS wizard creates synchronized snapshots on all the selected secondary hosts.

    This panel is displayed only in an environment using Volume Replicator (Volume Replicator). Otherwise, you are directly taken to the Schedule Information panel.

    See Volume Replicator Administrator's Guide.

  9. In the Schedule Information panel, on the General Options tab, specify the following:

    Name of this schedule

    Enter a unique name for the snapshot set schedule.

    This name identifies the snapshot schedule if you later want to view information about the snapshot status. A default name consists of the VSS writer name and a numbered suffix that increments with each schedule.

    Description of this schedule

    Optionally, enter a description to help you identify the schedule when you view information about the snapshot status.

    Start Time

    The time of the day to begin taking snapshots.

    End Time

    The time of day to end taking snapshots.

    If a snapshot is in progress it is completed but a new one is not started after the end time.

    Schedule takes effect on

    The date on which the specified schedule takes effect. The default is the current date.

    Restart task every

    The interval between snapshots, in minutes.

    For example, if the interval is 360 minutes and you schedule a snapshot start time of 12:00 P.M. and an end time of 7:00 P.M, the snapshot occurs twice. If no interval is specified the snapshot occurs once.

    Every

    Enable the Every option to have the snapshot schedule continue to occur. Otherwise the schedule applies only for one day.

    Specify the number of days before restarting the snapshot schedule.

    For example, 1 day would mean that the schedule takes effect daily, 2 days would mean every other day.

    Start On

    If you enable the Every option, specify the starting date.

    Pre Command

    Optionally, specify the full path of a command script to run before the scheduled snapshot occurs.

    Post Command

    Optionally, specify the full path of a command script to run after the snapshot is complete.

  10. To specify run days for the schedule, make selections on the following tabs:

    Days of Week

    Select one or more days on one or more weeks of the month.

    You can click a button at the top of the column to select the entire column or a button to the left of a row to select the entire row. For example, clicking First schedules the snapshots to occur on the first occurrence of all the week days for the month.

    Days of Month

    Select one or more days of the month. You can also check the Last Day check box to schedule the snapshot for the last day of each month.

    Specific Dates

    Select one or more specific dates to include in or to exclude from the schedule.

    Excluding a date takes precedence over days scheduled on the other tabs. For example, if you schedule every Monday on the Days of Week tab, and you exclude Monday October 9 on the Specific Dates tab, the snapshots are not taken on October 9.

    If two schedules overlap for the same snapshot set, only one snapshot is taken. For example, if you select every Thursday plus the last day of the month, and the last day of the month occurs on Thursday, only one snapshot is taken on Thursday.

  11. Click Next.
  12. Review the snapshot set and schedule details and click Finish.