Recovering data using Database Transactional logs

%3CLINGO-SUB%20id%3D%22lingo-sub-2267957%22%20slang%3D%22en-US%22%3ERecovering%20data%20using%20Database%20Transactional%20logs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2267957%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Colleagues%3C%2FP%3E%3CP%3EWe%20got%20%26nbsp%3Bour%20SQL%20Server%20database%20running%20MS%20dynamics%20affected%20by%20Malware%20specifically%20the%20Medusa%20locker%20%E2%80%9CReadInstructions%E2%80%9D%20malware.%3C%2FP%3E%3CP%3EThe%20closest%20functional%20backup%20we%20have%20is%20November%20and%20we%20have%20got%20it%20running.%20The%20database%20(.mdf)%20was%20messed%2C%20However%20the%20Database%20Transactional%20log%20file%20(.ldf)%20are%20available%20and%20up%20to%20date.%3C%2FP%3E%3CP%3EIs%20there%20any%20way%20of%20recovering%20data%20using%20the%20transactional%20log%20file%20that%20are%20up%20to%20date%3F%3C%2FP%3E%3CP%3EWould%20appreciate%20any%20support.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 and we have got it running. The database (.mdf) was messed, However the Database Transactional log file (.ldf) are available and up to date.

Is there any way of recovering data using the transactional log file that are up to date?

Would appreciate any support.

3 Replies

Hello @Ewere290 ,

 

In which recovery mode is the database?

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

 

Olaf

Dear Olafhelper,
It is in simple mode.

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.