What to Do When Ransomware Targets Database Files on a Local Server
A ransomware attack against a local database server can disrupt trading, bookings, payroll, stock control and customer access within minutes. Encrypted files may carry extensions you do not recognise, while the database service stops responding or displays a ransom note. Treat the event as a security incident, not simply a file-access problem.
The first priorities are to stop the encryption process, protect unaffected systems and preserve evidence. Avoid experimenting with random decryptors or repeatedly restarting the server. A careful response gives an Australian business a better chance of restoring records, meeting privacy obligations and identifying how the attackers entered.
Disconnect the Affected Server Carefully
Remove the compromised server from the network by disabling its switch port or unplugging its network cable, provided this can be done without destroying volatile evidence. Disconnect mapped drives, backup targets and replication links that may give the ransomware access to additional copies. Do not shut down every computer automatically; unaffected devices may contain useful logs and clean backups.
If the server hosts a virtual machine, isolate the guest and its virtual disks from other workloads. Do not delete ransom notes, suspicious scripts, encrypted database files or recently created administrator accounts. Record the time the incident was discovered, which systems are affected and any visible file extensions. This timeline can help an incident responder and may be important when reporting the breach.
Check whether the infection reached workstations, remote desktop hosts or cloud synchronisation folders. A browser hijacker or credential-stealing infection can be an early warning sign; guidance on malicious search-result changes explains why unusual browser behaviour should not be dismissed as a minor nuisance.
Protect Backups and Database Integrity
Do not attach backup disks or reconnect a network backup appliance until the ransomware’s access path is understood. Attackers commonly search for database dumps, snapshots and removable media. Mark the last known clean backup, its storage location and its retention status. Keep at least one copy offline or protected by immutable storage, and confirm that it can be read before relying on it.
Database files require special handling because a raw copy may be incomplete or internally inconsistent. Preserve the original encrypted files, transaction logs and configuration files. If the database service is still running, an administrator or forensic specialist should determine whether a consistent export is possible. Never overwrite the only copy while testing recovery software.
Check backup dates against Australian business activity. A retailer in Melbourne may need point-of-sale records from a busy weekend, while a professional practice in Perth may prioritise appointment and billing data. For businesses using Australian cloud or managed-service providers, request audit logs, snapshot details and access records rather than assuming the provider’s normal backup schedule covers this incident.
Find the Entry Point and Close It
Common entry routes include exposed Remote Desktop Protocol, stolen VPN credentials, malicious email attachments, unpatched internet-facing software and vulnerable SMB shares. Change privileged passwords from a known-clean device, revoke active sessions and disable unused accounts. Avoid changing evidence on the server before collecting relevant logs where possible.
Scan other Windows hosts and review firewall, VPN, identity and endpoint-protection alerts. A worm that spreads through file-sharing weaknesses can turn one infected machine into a network-wide event, so use this SMB worm removal guidance when checking lateral movement and exposed shares.
Patch operating systems, database platforms, hypervisors and remote-access tools after containment. Restrict administrative interfaces to approved management networks, require multifactor authentication for VPN and cloud accounts, and separate database servers from ordinary office devices. On smaller sites in Adelaide, Canberra or regional New South Wales, a managed service provider can help perform these changes when there is no in-house security team.
Decide Whether Recovery Is Safe
Do not treat a decryption key supplied by criminals as a guaranteed solution. Payment can fail, encourage further attacks and create legal, insurance or sanctions concerns. It also does not remove backdoors that may remain in the environment. Preserve the ransom note and wallet details for investigators, but do not communicate with the attackers from an infected workstation.
Recovery should begin with a clean, rebuilt server or isolated recovery environment. Apply current patches, install the database engine from trusted media and restore the earliest verified clean backup. Validate tables, indexes, permissions, stored procedures and application connections before reconnecting production users. Compare totals with paper records, exported reports or other independent sources where available.
Test the restored database with the application that depends on it. Confirm that dates, time zones, Australian Business Numbers, tax records and customer contact details are intact. Keep the encrypted originals preserved until the recovery has been audited and signed off by the business owner or technical lead.
Report the Incident and Prevent Recurrence
If personal information may have been accessed, assess the Australian Privacy Act and Notifiable Data Breaches requirements. The Office of the Australian Information Commissioner may need to be notified when a serious data breach is likely to cause harm. Businesses should also consider reporting through the Australian Cyber Security Centre’s ReportCyber service, contacting their insurer and informing affected partners where appropriate.
Engage qualified incident-response assistance if the database supports healthcare, financial services, education or critical operations. In Sydney, Brisbane and other major centres, local cybersecurity firms may provide forensic collection, while regional organisations can use remote response teams through their IT provider. Preserve email headers, firewall logs, authentication records and endpoint alerts instead of relying on screenshots alone.
After operations resume, document the attack path and recovery decisions. Use separate backup credentials, offline or immutable copies, routine restoration tests and least-privilege database accounts. Monitor for renewed access, and review endpoint protection across every device that handled the server’s credentials. If spyware may have captured passwords or tracked staff activity, follow a specialist spyware location guide while rebuilding trust in affected devices.