SQL database is crashed

[Former Member]

Hello,

Our 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. We also have a relatively old .BAK backup file.

Is it possible to bring the DB (.MDF) in the old backup to Live standard using the new/latest Log file? If so, how? Any help is truly appreciated.

[yakcinar]

Hello Michael,

First of all backup you DB + Log for the last moment. You can need it later.

If you have Full backup at some time and log backups from full backup time till now, you can restore your DB without data loss.

You can restore your DB either to your system (after backed up last situation) or to another server with SQL Server Instance with the same version of your original system.

Restore Full backup first then apply all log files.

You can use below links.

Restore a Database Backup (SQL Server Management Studio)

Backup and Recovery - SAP on SQL Server - SCN Wiki

Regarrds,

Yuksel AKCINAR