Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Other SQL Server Topics / November 2006

Tip: Looking for answers? Try searching our database.

restore sql 2000 bak to 2005

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
phil2phil - 22 Nov 2006 19:46 GMT
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.
Erland Sommarskog - 22 Nov 2006 22:15 GMT
> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.