Home Forums SQL Server 2008 SQL Server 2008 High Availability All the 3 jobs are running successfully but Restoration in Secondary server is not happening RE: All the 3 jobs are running successfully but Restoration in Secondary server is not happening

  • Go back to your primary and check that the backup job is running. Open the folder and check that the file is being placed where you expect. Basically, kick off the backup job and watch it put the file in the folder, then switch to the secondary, kick off the copy job and watch that it copies the file to the correct folder. Then if that works, manually kick off the restore job and watch that.

    I would also check your file retention settings on the secondary as it may be that you are deleting them too soon. How often does each job run?