Solved

Can a SQL Server database be recovered from a non-sql aware server image?

Posted on 2016-10-26
6
20 Views
Last Modified: 2016-10-27
A network administrator for a client used a system image backup process that was not SQL Server aware.   The customer inadvertently destroyed their SQL Server database and they are left with an actual SQL Server backup from May 2016 and the image files.  Is there an possibility of recovering the MDF and LDF files as a valid image to recover this database?
0
Comment
Question by:Tim Ragan
6 Comments
 
LVL 13

Assisted Solution

by:John Tsioumpris
John Tsioumpris earned 125 total points
Comment Utility
I guess the first thing to do is to try it...Just mount the image (it will show as another disk in your explorer) and find the .MDF/LDF file..
Copy them to Data directory of your SQL server (its the directory where master database is located)
Then use the option "Attach" to find and use your files.
0
 
LVL 5

Assisted Solution

by:mbkitmgr
mbkitmgr earned 125 total points
Comment Utility
I agree with John, extract a copy of the files relating to the Db in question and try to mount it.
0
 
LVL 45

Accepted Solution

by:
Vitor Montalvão earned 250 total points
Comment Utility
Is there an possibility of recovering the MDF and LDF files as a valid image to recover this database?
There's always possibility to things go well but in this case LDF file must be backed up correctly with no open transactions to keep the data integrity.
As the Experts stated above you can only know that after restoring. There's no other way to check that from an image file, I guess.
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

Author Comment

by:Tim Ragan
Comment Utility
Thanks everyone.  I had them get the MDF/LDF files and try them before I posted the question last night.  I've never had a customer who had no SQL specific backup process in place.  Their network admin "assumed" his daily service imaging was protecting everything.  I'm guessing they have not lost 6 months of data.  Wow.
0
 
LVL 45

Expert Comment

by:Vitor Montalvão
Comment Utility
Nowadays is quite acceptable to not have native SQL Server backups if you're using a good image backup tool. There are very good tools that can deal very well with SQL Server log files. They basically stops guarantee a checkpoint of the log files to allow the snapshot. This operation is so fast (micro or milliseconds) that you can't see the impact in the database.
0
 

Author Closing Comment

by:Tim Ragan
Comment Utility
All input appreciated!  I think this customer is in a pretty bad place.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

763 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

10 Experts available now in Live!

Get 1:1 Help Now