Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tribune
Posting Yak Master
105 Posts |
 Posted - 2004-05-06 : 16:50:15
|
| I can thank Norton Ghost for this one...I was ghosting a development database server, and it destroyed the partition/boot info on BOTH the source and destination drives. I managed to recover the database files, but I also need to recover the SQL agent jobs which I spent a while coding.How can I do this? The info is stored in the master database correct? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-06 : 16:59:18
|
| You need to restore the msdb database.Tara |
 |
|
|
tribune
Posting Yak Master
105 Posts |
Posted - 2004-05-06 : 17:09:12
|
| Will there be any adverse affects of restoring the MSDB on a freshly installed copy of sql? I just rebuild the machine, so... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-06 : 17:12:50
|
| There shouldn't be any problems.Tara |
|
|
|
|
|
|
Restoring SQL Jobs from a failed server