471,604 Members | 1,360 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,604 software developers and data experts.

restore sql 2000 bak to 2005

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\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.

Thanks.

Nov 22 '06 #1
2 8237
phil2phil (ph*********@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Nov 22 '06 #2
Yes i wanted to replace the existing on with this one.
Erland Sommarskog wrote:
phil2phil (ph*********@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Nov 29 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Utahduck | last post: by
3 posts views Thread by Bill E. | last post: by
5 posts views Thread by Seguros Catatumbo | last post: by
1 post views Thread by XIAOLAOHU | last post: by
reply views Thread by MichaelMortimer | last post: by
reply views Thread by CCCYYYY | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.