SQLServerAgent Stopped in SQL7

Question

SQLServerAgent Stopped in SQL7

Viewing 6 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

Restore MSDB from last good backup.

You do have backups of MSDB, don't you?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

lenymendoza SSC-Addicted Points: 414 More actions · Answer 2

you mean, I'll resotre the msdb from my backup server to the production? is it safe to do so? Thanks.

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 3

No, not at all.

I mean you need to restore from the database backups that you have taken of MSDB. As in RESTORE DATABASE msdb FROM ...

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

lenymendoza SSC-Addicted Points: 414 More actions · Answer 4

OMG..i dont have a backup of the msdb alone..

only the mdf file..

is there other way to do it?

My apology..im still new to database administration..huhu...thanks a lot for the support..

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 5

Then you will need to rebuild MSDB. You will lose all of your jobs, all of your backup history. I hope you have the jobs scripted somewhere.

I have no clue offhand how to rebuild MSDB in SQL 7. I suggest you hit google see if you can find any hits for a rebuild script for SQL 7, I'll ask some friends.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

lenymendoza SSC-Addicted Points: 414 More actions · Answer 6

thanks for the support..

:(, i hope you could still help me..