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 |
|
rds
Starting Member
2 Posts |
 Posted - 2005-12-25 : 23:52:55
|
| I am using SQL Server 2000 and have suddenly lost a hosted sql job which had been running for a year. The job was not backed up at all, only the dbases were backed up. Is there any way I can try to restore the job? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-12-26 : 00:24:08
|
| sql jobs are stored in the msdb database. if you are backing that one up you are ok. if not, you are SOL.just restore a copy of msdb to a test system and your job should be there.-ec |
 |
|
|
rds
Starting Member
2 Posts |
Posted - 2005-12-26 : 03:58:44
|
| Thanks. I dont have the msdb backup. Is is possible to restore the job from the transaction logs? |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-12-26 : 10:24:46
|
quote:
Originally posted by rds
Thanks. I dont have the msdb backup. Is is possible to restore the job from the transaction logs?
no. the msdb is in simple archiving mode, so there are no logs to look through. |
|
|
|
|
|
|
Lost a SQL server job