Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2016-10-26
6
40 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 15

Assisted Solution

by:John Tsioumpris
John Tsioumpris earned 125 total points
ID: 41861587
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
ID: 41861664
I agree with John, extract a copy of the files relating to the Db in question and try to mount it.
0
 
LVL 48

Accepted Solution

by:
Vitor Montalvão earned 250 total points
ID: 41861713
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:Tim Ragan
ID: 41862068
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 48

Expert Comment

by:Vitor Montalvão
ID: 41862078
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
ID: 41862423
All input appreciated!  I think this customer is in a pretty bad place.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

790 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