Re: dbcc dbrepair (drop database)
From: Richard Ding (rding_at_acadian-asset.com)
Date: 08/31/04
- Next message: GYK: "SQL Mail Session hangs"
- Previous message: Howard Long: "Re: How can i remove a server from enterprise manager"
- In reply to: Colleen: "dbcc dbrepair (drop database)"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 31 Aug 2004 10:41:10 -0400
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?
>
>
- Next message: GYK: "SQL Mail Session hangs"
- Previous message: Howard Long: "Re: How can i remove a server from enterprise manager"
- In reply to: Colleen: "dbcc dbrepair (drop database)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
