Re: Droping suspect publication database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Esio Nunes (esio_nunes_at_hotmail.com)
Date: 11/23/04 

Date: Tue, 23 Nov 2004 11:16:28 -0300

I restarted the server, but it doesn't work.

Ésio
"Reetesh B. Chhatpar" <reetesh@widesystems.com> escreveu na mensagem
news:exURfqV0EHA.3596@TK2MSFTNGP12.phx.gbl...
> If you have tried sp_resetstatus, I would just like to know whether you
> STOPPED and RE-STARTED services of SQL thereafter?
>
> I hope this helps !
>
> Reetesh B. Chhatpar
> ShawMan Software Enterprises
> www.shawmansoftware.com
>
> Diamond is just another piece of coal that did well under pressure.
>
>
> "Esio Nunes" <esio_nunes@hotmail.com> wrote in message
> news:Or%23B$gV0EHA.3120@TK2MSFTNGP12.phx.gbl...
> > Hi.
> > I have a publication databse that become suspect. It is a test database,
> and
> > I don't have backup.
> > I'm trying drop this, but I can't, SQL Server return a error message:
> Cannot
> > drop the database 'teste_replica' because it is being used for
> replication.
> >
> > I tried reset suspect status with sp_resetstatus but it doesn't worked.
> >
> > Any suggestion?
> >
> > Tanks.
> >
> > Ésio Nunes
> >
> >
>
>

Relevant Pages

  • Re: OCX Problem
    ... >> Reetesh B. Chhatpar ... >> ShawMan Software Enterprises ... >> Diamond is just another piece of coal that did well under pressure. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Problem with code not running in IDE
    ... Reetesh B. Chhatpar ... ShawMan Software Enterprises ... Diamond is just another piece of coal that did well under pressure. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: problem with fileopen
    ... Unfortunately, that's not the correct answer, Reetesh. ... dim directory as string ... "Reetesh B. Chhatpar" wrote in message ...
    (microsoft.public.vb.general.discussion)
  • Re: Decimal problem
    ... Reetesh B. Chhatpar ... ShawMan Software Enterprises ... Diamond is just another piece of coal that did well under pressure. ...
    (microsoft.public.sqlserver.programming)