Post reply

msdb(Suspect)

  • March 10, 2005 at 5:42 pm

    #166323

    Hello Gurus, here is my problem:

    SQL Server 2000 SP3a

    My msdb database has been marked suspect, I checked all error logs and nothing clear on them, it happened after a program hanged while recording a backup cd. I tried sp_resetstatus, but did not do anything. This has caused my SQL Agent to stop everytime the service is started, also all my DTS packages are gone I see 0 objects.

    Please help with any suggestions you may have.

    Thanks in advance

  • March 10, 2005 at 7:44 pm

    #546522

    Try rebooting the SQL Server first. Failing that, you will have to restore the MSDB Database! Thats assuming that you do have a good rescent backup of it!

    Kindest Regards,

Viewing 2 posts - 1 through 1 (of 1 total)

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