restore sql2000 db BAK file to sql2005
Posted on 2006-10-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.
Restore my bdname.BAK to sql2005