Forum Discussion

Ewere290's avatar
Ewere290
Copper Contributor
Apr 12, 2021

Recovering data using Database Transactional logs

Dear Colleagues We got  our SQL Server database running MS dynamics affected by Malware specifically the Medusa locker “ReadInstructions” malware. The closest functional backup we have is November ...
olafhelper's avatar
olafhelper
Bronze Contributor
Apr 12, 2021

Hello Ewere290 ,

 

In which recovery mode is the database?

You didn't mentioned any log backup, so it's mode "Simple"?

 

Olaf

Ewere290's avatar
Ewere290
Copper Contributor
Apr 12, 2021
Dear Olafhelper,
It is in simple mode.
  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Apr 13, 2021

    Then you have a problem.

    As soon as a transaction gets committed, the data in log is marked as done (released) and will be overwritten by later transactions.

     

    Without good backups I don't see a way to recover any lost data.