running a restore on serverB as part of backup job on serverA
jonesric
Posts: 25 Bronze 1
in SQL Backup
So here's my scenario;
serverA - backup job configured to run at 0001 to a local drive (& cloud); normally takes about 15mins to run
serverB - restore job configured to run at 0101, pointing at the local drive on serverA for the last full backup; normally takes around 30mins with a checkdb
normally, these 2 jobs run without any problems. However, recently, the backup job has taken longer than normal and has been running when the restore job kicks off, meaning the restore is picking up the previous nights backup to restore.
Is there a way of chaining the 2 jobs together - so the restore kicks off when the backup is complete, no matter how long it takes to run - either as step2 of the same job, or another way?
serverA - backup job configured to run at 0001 to a local drive (& cloud); normally takes about 15mins to run
serverB - restore job configured to run at 0101, pointing at the local drive on serverA for the last full backup; normally takes around 30mins with a checkdb
normally, these 2 jobs run without any problems. However, recently, the backup job has taken longer than normal and has been running when the restore job kicks off, meaning the restore is picking up the previous nights backup to restore.
Is there a way of chaining the 2 jobs together - so the restore kicks off when the backup is complete, no matter how long it takes to run - either as step2 of the same job, or another way?
Tagged:
Answers