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.