?
Solved

restore sql2000 db BAK file to sql2005

Posted on 2006-10-19
5
Medium Priority
?
499 Views
Last Modified: 2010-05-19
I got two problems this morning...

1- I got "Data error (cyclic redundancy check)."?? I'm able to log in at all. with query analyser too. My .mdf are corrupted.:( I don't know what happened last night. I ran chkdsk twice on all volume. In command prompt tool, I saw 20 errors but win2003 don't let me disamount my volume drive. I tried with wizard in computer management but it did nothing.

2- I can't export my db from sql2000 because My sql2000 crashed and when I tried to restore sql2000 db BAK file to sql2005 I got "restore failed for Server 'SERVLW01\SQLEXPRESS'.  (Microsoft.SqlServer.Express.Smo)"

My goal: restore my dbname.MDF file. I can copy that file to an another drive but what's next.
             OR
             Restore my bdname.BAK to sql2005

thanks


0
Comment
Question by:Silvertre
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 20

Accepted Solution

by:
Sirees earned 1500 total points
ID: 17767866
<<I can copy that file to an another drive but what's next>>

You need to attach the .mdf file in Mangement studio

check this link : http://msdn2.microsoft.com/en-us/library/ms190209.aspx

0
 

Author Comment

by:Silvertre
ID: 17768126
Ialready did that but dont works

how do i Restore my bdname.BAK 2000 to sql2005
0
 
LVL 20

Expert Comment

by:Sirees
ID: 17768220
0
 

Author Comment

by:Silvertre
ID: 17768326
Ok Remember before:
2- I can't export my db from sql2000 because My sql2000 crashed and when I tried to restore sql2000 db BAK file to sql2005 I got "restore failed for Server 'SERVLW01\SQLEXPRESS'.  (Microsoft.SqlServer.Express.Smo)"

I have no log file... only db .bak file.

I'm not sure but what you said before is it should work? but my .bak file is good because if i restore to an other pc.
0
 
LVL 20

Expert Comment

by:Sirees
ID: 17768471
Are the 2000 and 2005 machines same?

If the machines are not the same for backup and restore you might not have the drives / folders available as they are on the original system. If so you either have to create those folders or Restore the database with the WITH MOVE option to specify a new destination. (thats because the original location is tored in the backup file).
0

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question