Re: Suspect dB

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Hilary Cotter (hilaryk_at_att.net)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 13:14:05 -0500

did you try running a sp_resetstatus?
"Larry" <anonymous@discussions.microsoft.com> wrote in message
news:12dfa01c4166e$87f6d250$a601280a@phx.gbl...
> I am running Win 2K & SQL 2K.
>
> I had 3 dBs that are showing suspect in Enterprise
> Manager. I detached, then attached it, and it came back
> online. The other two dBs are distribution & StoreMain.
> I am unable to detach StoreMain or distribution because
> of replication.
>
> Some of the backups (dB backups & Trans Log backups) were
> deleted this AM, prior to this problem occurring.
>
> In addition to not being able to view anything in this
> dB, replication at my remote locations have failed.
>
> How can I fix this SUSPECT problem?
>
> Larry...

Relevant Pages

  • Suspect dB
    ... I had 3 dBs that are showing suspect in Enterprise ... I am unable to detach StoreMain or distribution because ... Some of the backups were ...
    (microsoft.public.sqlserver.server)
  • Suspect dB
    ... I had 3 dBs that are showing suspect in Enterprise ... I am unable to detach StoreMain or distribution because ... Some of the backups were ...
    (microsoft.public.sqlserver.replication)
  • Re: Suspect dB
    ... >> I had 3 dBs that are showing suspect in Enterprise ... >> I am unable to detach StoreMain or distribution because ... replication at my remote locations have failed. ... >> How can I fix this SUSPECT problem? ...
    (microsoft.public.sqlserver.replication)
  • Re: COpy Database
    ... looks like it didn't finishing attaching dbs. ... copy db wizard does detach and ... > I ran the copy database wizard to set up a job to copy three dbs from one ...
    (microsoft.public.sqlserver.server)