Thursday, March 22, 2012

Can not connect to Database

I'm using SQL Server 2000
I'm trying to store a database to a test database as I have done in the
past, now I'm getting an error message saying "Exclusive access could not be
obtained because the database is in use. RESTORE DATABASE is terminating
abnormally."
No is using this test database. Could someone tell me what is causing this
error and how can I solve this problem.
Thank you in advance,More than likely you have EM or QA pointing to it. In EM make sure you
click on an active node other than the db in question. Run sp_who2 or
sp_lock to see which spid is accessing the db.
Andrew J. Kelly SQL MVP
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:AE0CE4C0-2342-444E-8128-28795F6F1F7D@.microsoft.com...
> I'm using SQL Server 2000
> I'm trying to store a database to a test database as I have done in the
> past, now I'm getting an error message saying "Exclusive access could not
> be
> obtained because the database is in use. RESTORE DATABASE is terminating
> abnormally."
> No is using this test database. Could someone tell me what is causing this
> error and how can I solve this problem.
> Thank you in advance,
>

No comments:

Post a Comment