|
|
Posted by Erland Sommarskog on 11/22/06 22:15
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
Navigation:
[Reply to this message]
|