Suspect msdb

I have a SQL 2000 Server with a msdb database status of SUSPECT. I
already found a way of reseting its status in the master database, but
still can't recover it as it is in use.
I tried to stop the server and remove the mdf and ldf files in to
another directory so that I could run a script that recovers files by
using an alternative mdf and ldf files. Still i got nowere because (as
it should) sql server comunicates that the actual database files are
invalid and no recovering operation can be done since no files are
found.

NEED HELP ! All the maintenance and backup jobs are stuck in the msdb !

Please get back to me as soon as possible, since 3 main company
databases depend on this server !

Thanx in advance,

Carlos Mendes

--
This is an automatic signature of MesNews.
Site : http://www.mesnews.net

Carlos,

Have you tried to restore a backup of the MSDB?

HTH

Jerry
"Carlos Mendes" <cjmendes@confetil.com> wrote in message
news:mn.f45f7d59930699cf.27590@confetil.com...
>I have a SQL 2000 Server with a msdb database status of SUSPECT. I already
>found a way of reseting its status in the master database, but still can't
>recover it as it is in use.
> I tried to stop the server and remove the mdf and ldf files in to another
> directory so that I could run a script that recovers files by using an
> alternative mdf and ldf files. Still i got nowere because (as it should)
> sql server comunicates that the actual database files are invalid and no
> recovering operation can be done since no files are found.
>
> NEED HELP ! All the maintenance and backup jobs are stuck in the msdb !
>
> Please get back to me as soon as possible, since 3 main company databases
> depend on this server !
>
> Thanx in advance,
>
> Carlos Mendes
>
> --
> This is an automatic signature of MesNews.
> Site : http://www.mesnews.net
>

Hi,

After you used sp_resetstaus did you stop and start SQL Server service. This
will
recover the msdb database.
If this does not come up suspect then every thing should be OK. If not you
may need to restore a latest backup
of the msdb database.

Thanks
Hari
SQL Server MVP

"Carlos Mendes" <cjmendes@confetil.com> wrote in message
news:mn.f45f7d59930699cf.27590@confetil.com...
>I have a SQL 2000 Server with a msdb database status of SUSPECT. I already
>found a way of reseting its status in the master database, but still can't
>recover it as it is in use.
> I tried to stop the server and remove the mdf and ldf files in to another
> directory so that I could run a script that recovers files by using an
> alternative mdf and ldf files. Still i got nowere because (as it should)
> sql server comunicates that the actual database files are invalid and no
> recovering operation can be done since no files are found.
>
> NEED HELP ! All the maintenance and backup jobs are stuck in the msdb !
>
> Please get back to me as soon as possible, since 3 main company databases
> depend on this server !
>
> Thanx in advance,
>
> Carlos Mendes
>
> --
> This is an automatic signature of MesNews.
> Site : http://www.mesnews.net
>