Skip to main content

Hit by ransomware? Isolate affected systems now. Do not reboot or reformat.

SheMo Noransom舍末无勒

Case study

Mallox encrypts SQL Server and an ERP database at a manufacturing company

A shared SQL Server instance running production and finance data was encrypted by Mallox and the ERP client stopped working. Core data was recovered through file-level repair and log extraction, and the exposed 1433 port was closed.

Industry
Manufacturing Ransomware Response and Recovery
Family
Mallox
Scenario
SQL Server Encrypted
Handled
2025-11

This case study is composed from typical scenarios to illustrate our approach and the recovery paths involved. It does not describe a specific customer incident; real cases involving customer data are published only with authorization.

  • 约 95%

    Core business data recovered

  • 小时级

    Family identification

  • 约 3 个工作日

    Core system back online

  • 0

    Ransom paid

Incident background

The client is a mid-sized manufacturer whose production scheduling, warehouse and Kingdee finance systems share one SQL Server instance on a single Windows server, with database files and business attachments on the same disk.

To give branch plants and distributors access, port 1433 was mapped directly to the internet long-term, the sa account used a password that had not changed in years, and the service ran under an account with broad local privileges.

On Monday morning the shop floor reported that the ERP client would not log in. IT found the database service failing to start, data and log files carrying a new appended extension, and a ransom note on the desktop pointing to an email address. The backup job wrote to a second partition on the same server and was encrypted as well; an off-site backup approved the previous year had never actually been implemented.

Before calling us the client had already restarted the server and run a full antivirus scan, which moved the ransom note into quarantine.

What we did

Containment instructions went out on the first call: keep the server powered but off the network, stop all writes, pause every scheduled task, and make no further reboot or database repair attempt.

  • Evidence and imaging. Read-only images of the system and data disks, plus Windows security logs, SQL Server error logs and firewall traffic records. All subsequent work ran on copies.
  • Family confirmation. The ransom note was retrieved from quarantine; the extension, note text and contact format identified a Mallox build with no usable public decryptor, ruling out decryption.
  • Recoverability assessment. The encryptor had skipped and partially written the large MDF file, leaving substantial untouched data pages in the middle and tail sections; transaction log files were comparatively lightly damaged.
  • Recovery. Page-level scanning rebuilt the system and user table structures, usable pages were extracted table by table, and log replay filled in incremental records up to the outage. The result was exported to a fresh database. Most attachment files were recovered from unencrypted remnants and temporary directories.
  • Hardening in parallel. The public 1433 mapping was removed in favour of VPN access with multi-factor authentication, all database and system passwords were reset, and backup credentials were separated from production.

Recovery result

Core production and finance data were recovered to a point close to the outage. Mounted on a new instance, the ERP system logged in, queried and produced reports normally. A small number of postings not yet committed on the day of the incident could not be recovered and were re-entered by the finance team from paper documents and external statements, with the books reconciled within two business days.

Forensics showed the attacker brute-forced the sa account through the directly exposed 1433 port, then used the database's elevated privileges to execute system commands and deploy the encryptor. Logs contained days of consecutive failed logon attempts that no alert had ever covered.

Remediation covered: removing the public database port mapping, enabling MFA on the VPN, reducing the database service account's privileges, moving to a local-plus-offline two-copy backup design with one real restore exercise, and configuring alerts for anomalous logons and bulk file renaming. The client now reviews the exposure inventory quarterly.

This is an illustrative case compiled from typical scenarios and anonymized; it does not refer to any specific client.

Emergency response

Data already encrypted? Stop and let an engineer look first

We do not pay ransoms and we do not negotiate with attackers. Engineers run a free assessment first, then propose a recovery plan and a firm quote.