December 5, 2008 at 12:16 pm
Our DB crashed and we are on another machine, the database(s) are there, but the Nightly jobs are not. How could i retrieve those? I have all of the data from the old sql box.
Thanks
December 5, 2008 at 12:45 pm
Agent Jobs are stored in msdb - you could try restoring that database to the new system.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 6, 2008 at 8:58 am
you can also restore a copy of the database and pull the jobs out of it. and then put them into the new sytem.
December 6, 2008 at 10:00 am
Or create a quick VM, restore MSDB to a SQL instance there and then script out the jobs.
I'd keep a VM around for stuff like this, install Windows, SQL, then shut it down, mark it read only, and copy the files when you need a quick test system.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply