Posted by phil2phil on 11/29/06 20:18

Yes i wanted to replace the existing on with this one.


Erland Sommarskog wrote:
> phil2phil (philtwophil@yahoo.com) writes:
> > 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
> > doing:
> > Went to Restore Database in sql 2005, selected the db I want it
> > restored to, and File (say c:\temp\xyz.bak)
> > Checked the restore checkbox, went to options checked Overwrite the
> > existing database.
> >
> > Do I need to do anything else, maybe in the Restore the database files
> > as section? As those path are listed as:
> > C:\Program Files\Microsoft SQL Server\MSSQL\data\xyz.mdf
> > C:\Program Files\Microsoft SQL Server\MSSQL\data\xyz_log.ldf
> >
> > If I just run it without updating those mdf and ldf paths, I keep
> > 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?
>
>
> --
> 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

[Back to original message]