Cannot restore database

I have a couple of sql servers 2000 enterprise edition, that are giving me
trouble when I want to restore some databases. The server reports that the
database is in use but when I check using sp_who the specific databases are
not in use. The problem is solved when the server is stopped and restrated,
but I cannot imagine that this is the solution.
One server is an enterprise edition sp3
the other is a virtual server part of a win2000 cluster also sp3.
any ideas?
Thanks.
Ahmad El-Kays
Systems Developer
Maritz Canada Inc.
elkaysaz@.maritz.com
aelkays@.hotmail.comHow are you performing the restore? Via Query Analyzer or
Enterprise Manager?
In QA, make sure that you are not in the database your are
trying to restore. This is seen by the pull down menu. You
should choose to be in the master database.
In EM, do not select the database you are restoring. You
can right click on 'database' without expanding the tree
or expand the tree and right click on the master database
and choose to do the restore.
HTH
DeeJay
>--Original Message--
>I have a couple of sql servers 2000 enterprise edition,
that are giving me
>trouble when I want to restore some databases. The server
reports that the
>database is in use but when I check using sp_who the
specific databases are
>not in use. The problem is solved when the server is
stopped and restrated,
>but I cannot imagine that this is the solution.
>One server is an enterprise edition sp3
>the other is a virtual server part of a win2000 cluster
also sp3.
>any ideas?
>Thanks.
>
>Ahmad El-Kays
>Systems Developer
>Maritz Canada Inc.
>elkaysaz@.maritz.com
>aelkays@.hotmail.com
>
>.
>|||This is not the case. The database is not used at all. when sp_who is run
the database does not show up in the list at all. and YES the restore is
done in QA in the master db!
"DeeJay Puar" <deejaypuar@.yahoo.com> wrote in message
news:0dad01c368bc$d3b0b720$a301280a@.phx.gbl...
> How are you performing the restore? Via Query Analyzer or
> Enterprise Manager?
> In QA, make sure that you are not in the database your are
> trying to restore. This is seen by the pull down menu. You
> should choose to be in the master database.
> In EM, do not select the database you are restoring. You
> can right click on 'database' without expanding the tree
> or expand the tree and right click on the master database
> and choose to do the restore.
> HTH
> DeeJay
> >--Original Message--
> >I have a couple of sql servers 2000 enterprise edition,
> that are giving me
> >trouble when I want to restore some databases. The server
> reports that the
> >database is in use but when I check using sp_who the
> specific databases are
> >not in use. The problem is solved when the server is
> stopped and restrated,
> >but I cannot imagine that this is the solution.
> >
> >One server is an enterprise edition sp3
> >the other is a virtual server part of a win2000 cluster
> also sp3.
> >
> >any ideas?
> >
> >Thanks.
> >
> >
> >Ahmad El-Kays
> >Systems Developer
> >Maritz Canada Inc.
> >elkaysaz@.maritz.com
> >aelkays@.hotmail.com
> >
> >
> >.
> >