Solved

restore sql2000 db BAK file to sql2005

Posted on 2006-10-19
5
491 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 500 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

740 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