In what database are the backup devices kept?

[bessebo]

I would've thought they would be in the msdb database but they aren't...

 

[ptheriault]

select * from master.dbo.sysdevices

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[bessebo]

Thanks for that. Hey, I have another issue with my msdb database. It has consistency errors and I want to restore from an older backup of msdb. I did this in my Test Environment, the errors go away. But when I try to update a job I get this error: Error 14724; Cannot add, update, or delete a job (or its stels or schedules) that originated from an MSX server.

I did some research and it appears to be the fact that I am restoring to a server with a different name. I think I will not have this issue if I restore to the same server that the backup came from. In other words, if I restore the msdb database in production I should be able to update the jobs in there. What do you think?

Thanks,
Bessebo

 

[ptheriault]

you won't have that issue if you restore the database to the same server. to fix it on your test server change the originating_Server column in msdb.dbo.sysjobs to the name of your current test server.

- Paul
- If at first you don't succeed, find out if the loser gets anything.