PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Scheduling Microsoft SQL Server backups by using Windows Task Scheduler

To schedule Microsoft SQL Server backups by using Windows Task Scheduler, perform the following steps:

1. On the Windows desktop, click Start > All Programs > Accessories > System Tools > Task Scheduler.
2. In the left pane of the Task Scheduler window, right-click Task Scheduler Library, and then select Create Basic Task.

   The Create Basic Task Wizard wizard appears.

3. On the Create a Basic Task page, in the Name field, type a name for the task, and then click Next.
4. On the Task Trigger page, select the appropriate option to start the task, and then click Next.

   The page that corresponds to the selected option appears.

5. Specify or select all the fields that you require to perform the task, and then click Next.
6. On the Action page, select Start a program, and then click Next.
7. On the Start a program page, browse for the .bat file and in the Program/script field, type the file path, and then click Next.
8. On the Summary page, review the details of the task, and then click Finish.

   The process creates the task and adds it to your Windows schedule.