Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

restore sql2000 db BAK file to sql2005

Posted on 2006-10-19
5
Medium Priority
?
500 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
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.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

636 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