Hello everyone!
I have a SQL environment where the error below started appearing after migrating between repositories:
With this error it won't let me:
- Delete the jobs;
- Enable the job;
- Finalize the job configuration summary;
Nothing about that specific job has worked again!!
Background:
Previously we needed to move the backup file and then map them to their target repository.
Today we have the “Move backup” option:
After clicking move, it tells me that it needs to move all the cluster backups:
In addition to enabling Move via console, we can also choose which Job it will be linked to:
That's awesome!
Now let's get back to troubleshooting!
I executed the sequence below to solve the problem:
- Clone the current job;
- Move the backups to the repository and cloned job;
- Run full backup;
- Continue transaction log;
After that my job is working perfectly!
Remembering that I am using Windows Agents within a protection group as good practices for Always ON protection
