Schedule a Microsoft SQL Backup in LiveVault

This topic pertains to Microsoft SQL backup policies, which LiveVault supports on SQL Server 2005 and later.

To back up earlier versions of SQL Server, you must use a standard backup policy.

Backup runs according to a backup schedule defined by one of several means.

• Backup schedules defined by default by your subscription and the service level to which you subscribed.

• If you have appropriate rights, by a custom schedule you define.

You can use a different schedule for each policy. If you have multiple backup policies, each policy's schedule is independent of the other policies. Under Windows, your backups run continuously by default, but you can change the policies to run under a different schedule.

The Backup Schedule Grid

To specify the intervals when a backup runs for the policy, use the grid that consists of hours of the day and days of the week. An interval can consist of one or more successive half-hours, and can span multiple days. Unless the backup is continuous, only one backup runs during each interval. All schedules run based on your computer's time zone. For example, a backup scheduled to begin at 10:00 p.m. will begin when it is 10:00 p.m. on the computer on which the backup is scheduled to run.

To schedule a backup

1. On the Backup Configuration page, click the Schedule tab.

2. Specify when you want to run this backup policy.

   Note: LiveVault may not offer automatic scheduling of backup intervals. This is determined by your subscription.

• To specify when backups will run, click a selection in the list.

  Note: The schedules below are examples only. The available schedules vary depending on the subscription to which you are subscribed:

  Click...	To...
  Continuous	Windows only. Create a schedule where backup runs 24 hours a day, 7 days a week.
  Nightly	Create a schedule where backup runs from 8:00 p.m. to 5:00 a.m. every evening.
  Weekends	Create a schedule where backup runs from 8:00 p.m. to 5:00 a.m. on only Saturday and Sunday evenings.
  Custom	If you have the appropriate rights to create a custom schedule, specify a custom schedule for when you want backup to occur. Specify a custom schedule for when you want backup to occur. Click the squares in the schedule grid to set up intervals when backup will run. The grid consists of hours of the day (columns) and days of the week (rows). Each horizontal row identifies a day of the week, with Monday at the top. The first time period (left edge of the grid) is 12:00 a.m. (midnight). Each square on the grid represents a half-hour segment. Click each square individually to toggle on and off intervals. Click a square and drag the mouse across the successive squares to toggle on and off intervals. Click a square and drag the mouse diagonally across successive squares to toggle one and off intervals.

• Backup starts at the beginning of each interval.

  Note: When you select your backup intervals, if you span multiple hours or days with connecting intervals in the schedule grid, only one backup will run for the entire span. If you need multiple backups to run every few hours, for example, select alternate squares on the grid. The Schedule notation in the legend under the grid shows how many backups are scheduled per week based on your selections..

Local Time Zone

The schedule grid represents the time zone on the agent computer that is being backed up. For example, if you select the square for 7:00 p.m. on the schedule grid, the backup starts when it is 7:00 p.m. on the agent computer. The time zone is based on Greenwich mean time, plus or minus the correct number of hours for the time zone adjustment. If the computer's date/time properties are set to adjust for daylight savings time, the time zone also reflects daylight savings time.