how to recover from suspect mode distribution database

Put the database into emergency mode and attempt to bcp the data out.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kuba Guszkiewicz [cs]" <k.gluszkiewicz@.citysoftware.com.pl> wrote in
message news:%23Qw%23$mvZHHA.1388@.TK2MSFTNGP05.phx.gbl...
> Hi ng,
> during this night big (3GB) log file in my distribution database was
> corrupted,
> now my database is in suspect mode,
> is the any solution to recover database from this mode? for ex.: use bcp
> or something?
> i need this replication working...
> if anyone knows the solve please answer me,
> i will be very gratefull for step by step instructions
> thanks in advance
> kg
>
Try this, script out all publications and subscriptions. Then drop the
database, and recreate it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kuba Guszkiewicz [cs]" <k.gluszkiewicz@.citysoftware.com.pl> wrote in
message news:u3Sha4wZHHA.5020@.TK2MSFTNGP05.phx.gbl...
> Hilary,
> thanks, but what's next?
> i have to run bcp on each table or exist any bcp instuction which can i
> out all data?
> could you give me next step?
> i have to delete database?
> please help
> thanks
> --
> pozdrawiam
> Kuba Guszkiewicz
> k.gluszkiewicz@.citysoftware.com.pl
> tel. 509-650-351
> (22) 711-26-45
> (22) 711-26-46
> fax (22) 711-26-47
> Uytkownik "Hilary Cotter" <hilary.cotter@.gmail.com> napisa w wiadomoci
> news:O8T2vywZHHA.2432@.TK2MSFTNGP03.phx.gbl...
>
|||Ok, script out all your publications and subscriptions.
try to remove replication, by disabling it.
If this fails try the following:
sp_dropdistpublisher
if this doesn't work try it with sp_dropdistpublisher @.no_checks=1 and then
if this fails sp_dropdistpublisher @.no_checks=1 , @.ignore_distributor=1
Then
sp_dropdistributor
again if this fails try it with @.no_checks and then @.ignore_distributor
Then
sp_dropdistributiondb
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Kuba Guszkiewicz [cs]" <k.gluszkiewicz@.citysoftware.com.pl> wrote in
message news:eitJ0fzZHHA.4136@.TK2MSFTNGP04.phx.gbl...
> thanks for any advice, but i need more detailed advice,
> Hilary could you help?
> Uytkownik "Hilary Cotter" <hilary.cotter@.gmail.com> napisa w wiadomoci
> news:%23Pgb$UxZHHA.3968@.TK2MSFTNGP06.phx.gbl...
>