> I have an old 2000 bak file for a db that I would now like restored
> onto sql server 2005. I keep erroring out though, this is what I'm
[quoted text clipped - 12 lines]
> getting an error:
> Exclusive Access could not be obtained because the database is in use.
Apparently there are one or more processes active in that database. Be
careful, it could be yourself. For instance, if you are on that node
in the Object Explorer.
Do you want to replace the existing database with the backup?

Signature
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
phil2phil - 29 Nov 2006 20:18 GMT
Yes i wanted to replace the existing on with this one.
> > I have an old 2000 bak file for a db that I would now like restored
> > onto sql server 2005. I keep erroring out though, this is what I'm
[quoted text clipped - 26 lines]
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx