Re: Can't take db offline
From: Rick Sawtell (quickening_at_msn.com)
Date: 11/23/04
- Next message: Rick Sawtell: "Re: Transaction log file is full"
- Previous message: Hai: "Transaction log file is full"
- In reply to: DBA: "Can't take db offline"
- Next in thread: Uri Dor: "Re: Can't take db offline"
- Reply: Uri Dor: "Re: Can't take db offline"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 23 Nov 2004 15:15:17 -0600
"DBA" <DBA@discussions.microsoft.com> wrote in message
news:B16E4BFD-5BC0-4FEE-B53E-53F22D10CFA9@microsoft.com...
>I have an ERP system, and I am try to take the db offline to restore, but
>it
> will not. Any suggestions. I even rebooted
Run sp_who to see who is currently connected to the database.
You can then use the KILL command to kill off the spids who are connected.
Once that is done, you should be able to put the database in db use only.
Rick Sawtell
MCT, MCSD, MCDBA
- Next message: Rick Sawtell: "Re: Transaction log file is full"
- Previous message: Hai: "Transaction log file is full"
- In reply to: DBA: "Can't take db offline"
- Next in thread: Uri Dor: "Re: Can't take db offline"
- Reply: Uri Dor: "Re: Can't take db offline"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
