Friday, March 9, 2012

How to drop a database in loading / suspect mode

I tryed a "point in time restore" of a database which is used for replication
into a new database. This restore failed and the database is now in loading /
suspect mode. How can I delete this database.
When I try to drop the database e.g. in enterprise manager I get Error 3724
(used for replication). To stop the replication isn't possible either because
the "restore is in process".
Thanks for your help
UrsFunny enough I had this problem the other day.
I solved it by cancelling the process that was doing the
restore, then detaching and re-attaching the database.
Worked fine after that.
(NB my replication had stopped)
Peter
"Cauliflower is nothing but cabbage with a college
education."
Mark Twain
>--Original Message--
>I tryed a "point in time restore" of a database which is
used for replication
>into a new database. This restore failed and the database
is now in loading /
>suspect mode. How can I delete this database.
>When I try to drop the database e.g. in enterprise
manager I get Error 3724
>(used for replication). To stop the replication isn't
possible either because
>the "restore is in process".
>Thanks for your help
>Urs
>.
>

No comments:

Post a Comment