Why when trying to restore a SQL DB from backup, it keeps referring to backup's original location an
- by rm
I've done a full DB backup to C:\Backups\MyDb.bak
Then I've setup a job to incrementally back the DB up every day to that same location.
Then I've moved the backup files to X:\Backups\, changing the target directory in backup job
Now that I try to restore the database from backup, it keeps trying to refer to C:\Backups\MyDb.bak, but that file is no longer there.
How do I fix the issue w/o having to move the backup files back to C:\Backups?