|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > CANT DELETE DB
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]
|
|
|
| Ran the following command: RESTORE DATABASE DBNAME FROM
DISK = " e:\download\DBNAME.BAK " WITH NORECOVERY GO
DB grayed out in Ent. Manager, says loading, I can't
delete it or do anything with it. DB has no logs to
restore (so NORECOVERY option was wrong). Please advice on
how to make DB accessible, or at least how to delete it
(SQL Server won't delete it, says error 3724 Cannot drop
the database ... because it is being used for
replication).
Any help will be appreciated...
| |
| Allan Mitchell 2002-11-01, 3:23 pm |
| RESTORE DATABASE DBNAME WITH RECOVERY
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE, MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community for SQL Server
professionals - http://www.sqlpass.org
| |
| Ron Talmage 2002-11-01, 9:23 pm |
| If the database is a publisher database, you can remove its marking for
replication by applying sp_dropdistpublisher with @no_checks = 1
Ron
--
Ron Talmage
SQL Server MVP
"dmcub" <dmcub@yahoo.com> wrote in message
news:37da01c281e6$7196bac0$36e
f2ecf@tkmsftngxa12...
> Ran the following command: RESTORE DATABASE DBNAME FROM
> DISK = " e:\download\DBNAME.BAK " WITH NORECOVERY GO
>
> DB grayed out in Ent. Manager, says loading, I can't
> delete it or do anything with it. DB has no logs to
> restore (so NORECOVERY option was wrong). Please advice on
> how to make DB accessible, or at least how to delete it
> (SQL Server won't delete it, says error 3724 Cannot drop
> the database ... because it is being used for
> replication).
>
> Any help will be appreciated...
|
|
|
|
|