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

Posted on 2011-10-19
Last Modified: 2012-05-12
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.
Question by:chuang4630
    LVL 1

    Author Comment

    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?
    LVL 142

    Accepted Solution

    if you can get all the .mdf and .ldf files, which need to be in a consistent state, you can attach the user databases:

    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
    LVL 10

    Assisted Solution

    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 , 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

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
    The viewer will learn how to successfully download and install the SARDU utility on Windows 7, without downloading adware.

    746 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

    14 Experts available now in Live!

    Get 1:1 Help Now