How to restore a database using mdf and ldf files in Sql 2008?

Question

5.00/5 (1 vote)

See more:

SQL-Server-2008R2

Hello,
Asking for expert opinion. A very unfortunate event happened. One of our PCs crashed few days ago. That PC had SQL Server 2008 installed. Unfortunately no backup was running on that server. We sent the disk to a data recovery place and looks like they can recover some of the mdf and ldf files. We are particularly interested in 1 particular database. My questions are:
1. Is this possible to restore a particular database using corresponding mdf and ldf files?
2. Do we need to have any mdfs from the system databases? Any other files we need to ask data recovery company t look for?
3. Steps and/or or best practices to restore that database into a new machine.
Thanks for your help in advance.

Posted 10-Nov-15 10:34am

Member 12123895

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Timmermanss · Accepted Answer · 2015-11-12T06:44:00

You can attach the database files to another instance if you have the mdf' and ldfs ( even with mdf you will be able to attach )
System database master contains the user info, and msdb contains the jobs and other info; if you couldn't recover these files, you need to add them manually
ssms -> rightclick database -> attach ; choose the files and attach
OR
You may have to run a 'DBCC CHECKDB()' statement against the newly attached database

Timmermanss · Accepted Answer · 2015-11-12T06:45:00

Solution 2

2) You can copy the .mdf and .ldf files to a different server and just Attach them.
https://msdn.microsoft.com/en-us/library/ms190209.aspx
You will lose any server-wide logins created at the instance level but you will retain your database users.

Posted 12-Nov-15 6:45am

Timmermanss

Timmermanss · Accepted Answer · 2015-11-12T06:47:00

3) If the database is not open, then I think the files could be damaged. see this support article from microsoft. https://support.microsoft.com/en-us/kb/288809[^]
If this does not help, then only have the option to try third-party program. Can in the Market to look for or can use like SQL Server Recovery Toolbox. I as the expert recommend it to you. Or can use any other tool known to you. http://www.oemailrecovery.com/sql_repair.html
So I told you all the possible ways.)

Timmermanss · Accepted Answer · 2015-11-12T07:02:00

Solution 4

Look at this resource, you might find more useful information. http://community.office365.com/en-us/f/172/t/266070.aspx

Posted 12-Nov-15 7:02am