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,
>

Can I install sql server 2000 and sql server 2005 in the same machine

Hello ,

i am an asp.net developer my pc has sql server 2005 already and now my company use sql server 2000

I think 2005 is very easy to use but some of 2000 that I don't know

so can I install 2000 in the same machine with 2005 ?

thanks for your kindness.

Kate

You definetely can. Go ahead and have fun.

|||By the way, if you need to connect to a 2000 DB, you dont need to install 2000 on your local machine. You can still connect to the company DB through your 2005 Management Studio. Just register the server and you can run your usual queries.|||

OK I will do it tonight, thanks for your help.

Regards,

Kate