|
Home > Archive > MS SQL Server > September 2005 > Suspect msdb
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Carlos Mendes 2005-09-30, 1:23 pm |
| 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
| |
| Jerry Spivey 2005-09-30, 1:23 pm |
| 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
>
| |
| Hari Prasad 2005-09-30, 8:23 pm |
| 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
>
|
|
|
|
|