Scheduling restore jobs
Published 13 February 2013
SQL Backup Pro provides a wizard to guide you through the process of setting up scheduled restore jobs. To start the Schedule Restore Jobs wizard, clickSchedule Restore Jobs.
You can use the Schedule Restore Jobs wizard to:
- Set up a regular restore of a database from the latest backup.
- Set up backup verification by including a database integrity check (DBCC CHECKDB) as part of the scheduled restore job. See Backup verification for more details.
- Regularly refresh a development environment.
To edit a scheduled restore job using the Edit Restore Jobs wizard, select the job in the Jobs tab.
The Schedule Restore Jobs wizard comprises the following steps:
|Step 1:||Select the SQL Server you want to restore to and the backup files to restore.|
|Step 2:||Specify the destination database.|
|Step 3:||Specify the location of the database files.|
|Step 4:||Specify verification options for the restored database.|
|Step 5:||Configure your settings for restoring the backups.|
|Step 6:||Define the details of the job schedules.|
|Step 7:||Review the restore summary and script, and create the restore jobs.|
Scheduling restore jobs with SQL Server Express Edition
With SQL Server Express Edition, you can use the SQL Backup Pro GUI to take ad hoc backups and restores. However, you cannot set up scheduled backup jobs, scheduled restore jobs, or log shipping, because SQL Server Express Edition lacks the SQL Server Agent (which SQL Backup Pro uses to schedule jobs).
You can still schedule restores using the Windows Task Scheduler (found in the Windows Control Panel) and SQL Backup Pro's command line interface,
- Go through the Restore wizard to create a template restore job for the database you want to schedule jobs for.
- On step 4 of the wizard, choose the command line version of the script, and copy it.
- In the Windows Control Panel, open Task Scheduler and create a new task.
- On the Actions tab, create a new action which starts a program, and paste the command line script from the Restore wizard into the Program/script box.
- On the Triggers tab, create the schedule on which you want to run your restore job.
- Click OK to create the scheduled task.
The restores will be listed in the Activity History, but the task will not be listed in the Jobs tab.
For more information about the command line interface, see Using the command line.
For more information about the Restore wizard, see Restoring backups.
Didn't find what you were looking for?
- Visit the Redgate forum
- Contact Support