restore sql2000 db BAK file to sql2005

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


SilvertreAsked:
Who is Participating?
 
SireesConnect With a Mentor Commented:
<<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
 
SilvertreAuthor Commented:
Ialready did that but dont works

how do i Restore my bdname.BAK 2000 to sql2005
0
 
SireesCommented:
0
 
SilvertreAuthor Commented:
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
 
SireesCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.