Thursday, March 8, 2012

dbcc dbrepair (drop database)

I need to drop a damaged database and BOL no longer provides the syntax for
dbcc dbrepair. Drop database doesn't work because it's being replicated.
The database is in a 'loading' state, but is not actually being restored.
When I issue drop database command it tells me it can't because it's being
replicated. This is true but I can't get rid of the publications because
it's in the 'loading' state.
Anyone know the syntax for dbcc dbrepair or how I can drop this database?
A database in loading status can't be a publisher. If it's a subscriber, you
should be able to drop it.
Any reason why it's in loading?
"Colleen" <Colleen@.discussions.microsoft.com> wrote in message
news:90A47C0C-F0B0-41E5-B58A-668A785B90FC@.microsoft.com...
> I need to drop a damaged database and BOL no longer provides the syntax
for
> dbcc dbrepair. Drop database doesn't work because it's being replicated.
> The database is in a 'loading' state, but is not actually being restored.
> When I issue drop database command it tells me it can't because it's being
> replicated. This is true but I can't get rid of the publications because
> it's in the 'loading' state.
> Anyone know the syntax for dbcc dbrepair or how I can drop this database?
>

No comments:

Post a Comment