Solved

restore sql2000 db BAK file to sql2005

Posted on 2006-10-19
5
481 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
  • 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
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.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

863 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now