SQL Server Virus Attack - Recover main database (MDF) using log (LDF) file

Hi ! My server was hit by some unknown virus which seems to have corrupted header information for many of our files including an important databases and some of its backups. However the log file (.LDF) for the live DB was not affected. I also have a relatively old .BAK backup file.

avatar image By nobel34 0 asked Dec 01, 2014 at 01:54 PM
more ▼
(comments are locked)
avatar image Stephen Dyckes ♦ Dec 01, 2014 at 08:24 PM

While there is a potential to recover a database with only the MDF file, you cannot recover a database with only the LDF file.

If the log backups have not been corrupted, the log chain has not been broken, and you have all the log files from the last good Full backup, you can utilize them to restore the database.

If you do not have backup files (both full and Tlog) that have not been corrupted, then you are in a very unfavorable position. Paul Randal has some excellent posts on potentially using a Hex editor to try to alter files of databases, though this would be the absolute last resort! Here is one such post. For additional information search the SQL Skills site for corruption.


avatar image jason_clark Oct 17, 2017 at 11:32 AM

Repair corrupt or damaged SQL database using an effective tool SQL database recovery tool. This tool easy to resolve all types corruption issues. The tool also recovers all tables, stored procedure, functions, views, rules, triggers and associated Primary Key, Unique keys, data types & all other components. It supports all versions of MS SQL server and all updated Windows OS versions. Visit here - http://www.mdfviewer.com/recovery/

avatar image daisysmith25 Feb 07 at 05:22 AM

No problem you can easily recover your complete MS SQL database from corrupt database, with the help of a third party software, such as, Kernel for SQL database recovery software. The software is compatible with all MS SQL file formats. It free trial version is also available to evaluate its features and functionalities. For more information about the software, visit- https://www.kerneldatarecovery.com/sql-recovery.html

10|5000 characters needed characters left

0 answers: sort voted first