Click here to Skip to main content
15,662,893 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
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.

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
You may have to run a 'DBCC CHECKDB()' statement against the newly attached database
Share this answer
2) You can copy the .mdf and .ldf files to a different server and just Attach them.
You will lose any server-wide logins created at the instance level but you will retain your database users.
Share this answer
3) If the database is not open, then I think the files could be damaged. see this support article from microsoft.[^]
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.
So I told you all the possible ways.)
Share this answer
Look at this resource, you might find more useful information.
Share this answer

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900