Scheduling Microsoft SQL Server backups

After the virtual machine backup schedule is created, you can create the Microsoft SQL Server backup schedule.

About this task

The frequency of the backups is determined by the recovery point objectives (RPO).

Procedure

  1. Start the Data Protection for Microsoft SQL Server user interface from the virtual machine that is hosting Microsoft SQL Server.
  2. In the navigation pane, expand the Manage node.
  3. Under the Manage node, right-click Scheduling > Scheduling Wizard.
  4. Open the Scheduling Wizard to identify the schedule name and time.
  5. For the Define the Scheduled Task page, select Command Line.
  6. Click the icon to select the SQL Server template. Click Next.
  7. Use the command-line interface and SQL Server template to specify the database log backup, for example: 
    tdpsqlc backup * log /truncate=yes 2>&1
    Tip: Alternatively, you can schedule Microsoft SQL Server backups by using the Tivoli® Storage Manager centralized scheduling service. This service helps you to create a backup schedule for all Microsoft SQL Server instances on a virtual machine.