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

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?
Tim RaganAsked:
Who is Participating?
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
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
 
John TsioumprisConnect With a Mentor Software & Systems EngineerCommented:
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
 
mbkitmgrConnect With a Mentor Commented:
I agree with John, extract a copy of the files relating to the Db in question and try to mount it.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
Tim RaganAuthor Commented:
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
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
Tim RaganAuthor Commented:
All input appreciated!  I think this customer is in a pretty bad place.
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.

All Courses

From novice to tech pro — start learning today.