Silvertre
asked on
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.Expre
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
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.Expre
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.Expre
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.
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.Expre
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.
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).
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).
ASKER
how do i Restore my bdname.BAK 2000 to sql2005