restore sql 2000 bak to 2005

[phil2phil]

Hi,
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\da ta\xyz.mdf
C:\Program Files\Microsoft SQL Server\MSSQL\da ta\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.

Thanks.

[Erland Sommarskog]

Re: restore sql 2000 bak to 2005

phil2phil (philtwophil@ya hoo.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\da ta\xyz.mdf
C:\Program Files\Microsoft SQL Server\MSSQL\da ta\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@sommarsk og.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]

Re: restore sql 2000 bak to 2005

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


Erland Sommarskog wrote:

phil2phil (philtwophil@ya hoo.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\da ta\xyz.mdf
C:\Program Files\Microsoft SQL Server\MSSQL\da ta\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@sommarsk og.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/prodinf...ons/books.mspx