• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 310
  • Last Modified:

How to get retrieve my SQL data from the old hard drive

I have a SQL Server 2008 R2 installed on my old PC (Windows 7). Unfortunately, it is dead yesterday. The hard drive is still okay.  

I use another Windows 7 PC right. How do I retrieve the data file from taht old hard drive. I did not run the sql backup for a long time.
0
chuang4630
Asked:
chuang4630
2 Solutions
 
chuang4630Author Commented:
I use another Windows 7 PC right now. How do I retrieve the data file from that old hard drive. I have not run the sql backup for a long time. Can I still retrieve it?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
if you can get all the .mdf and .ldf files, which need to be in a consistent state, you can attach the user databases:
http://msdn.microsoft.com/en-us/library/ms190209.aspx

this won't work for master/msdb databases, though!

to "restore" master, you need to have a backup, unless you manage to install the sql server on exactly the same locations (path) than the old box.
but still, it is likely that the master database files are not consistent, if the old box is "dead".

hope this helps
0
 
Ramesh Babu VavillaCommented:
if you can get mdf and ldf file from your had disk you can attach the db and start working, if you get mdf file only , you can use http://www.sqlrecoverytool.com/ , rthird party recovery tool to extract the db from it, but all the open transaction when extracting from ldf as all the open tran are on the ldf 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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now