>Bcp.exe
Microsoft SQL Server Bulk Copy Program utility for importing and exporting data between SQL Server instances and data files.
Default Executable Paths
C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\bcp.exeC:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\bcp.exeC:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\bcp.exeC:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\bcp.exeC:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\bcp.exeC:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\bcp.exeC:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\bcp.exeIntegrity & Metadata
Documented in LOLBAS project by Mahir Ali Khan.
Monitor process creation events where FileName is "Bcp.exe" or command line references known attack arguments.
Executive Summary & AI Quick Reference
Bcp.exe is a native utility pre-installed on Windows systems. Threat actors and red teams abuse Bcp.exe as a Living-off-the-Land Binary (LOLBin) to achieve Download without triggering traditional antivirus file-hash alerts. Legitimate system administrators use it for routine administration, making behavioral command-line telemetry essential for differentiation.
Weaponized Parameters & Proof-of-Concepts
Documented attack commands, parameter flags, and privilege prerequisites.
Export binary payload stored in SQL Server database to file system.
bcp "SELECT payload_data FROM database.dbo.payloads WHERE id=1" queryout "C:\Windows\Temp\payload.exe" -S localhost -T -cSIEM & EDR Detection Rules
Production telemetry rules configured for Microsoft Defender, Sigma, and Splunk.
Telemetry & SIEM Detection Suite (Bcp.exe)
Validated against MITRE T11051// Microsoft Defender XDR / Microsoft Sentinel2// Tactic: Download3DeviceProcessEvents4| where FileName =~ "Bcp.exe"5| where ProcessCommandLine has_any ("Bcp")6| project7 Timestamp,8 DeviceName,9 AccountName,10 InitiatingProcessParentFileName,11 InitiatingProcessFileName,12 InitiatingProcessCommandLine,13 FileName,14 FolderPath,15 ProcessCommandLine,16 MD5,17 SHA25618| sort by Timestamp descMitigation, Hardening & Prevention
Recommended defensive controls to block or constrain Bcp.exe abuse.
Enforce Windows Defender Application Control (WDAC) or AppLocker publisher rules to prevent execution outside approved enterprise administration scripts.
Enable ASR rules: Block executable content from email client and webmail and Block Office applications from creating child processes spawning Bcp.exe.
Deploy the KQL, Sigma, and Splunk detection queries below. Alert on anomalous child processes, web requests to unrated external IPs, or encoded payload strings.
Frequently Asked Questions (FAQ) • Bcp.exe
Key operational questions and defensive answers about Bcp.exe LOLBin tradecraft.
What is Bcp.exe and why is it classified as a LOLBin?
Bcp.exe is a legitimate, pre-installed or trusted utility on Windows. It is classified as a Living-off-the-Land Binary (LOLBin) because adversaries abuse its built-in functionality to perform malicious operations—such as Download—without dropping custom malware binaries on disk.
How do threat actors abuse Bcp.exe in cyber intrusions?
Adversaries leverage Bcp.exe to execute stealthy actions while evading signature-based security controls. For example, attackers execute commands like "bcp "SELECT payload_data FROM database.dbo.payloads WHERE id=1" queryout "C:\Windows\Temp\payload.exe" -S localhost -T -c" to achieve Download, masquerading behind legitimate system process lineage.
How can SOC analysts detect suspicious Bcp.exe activity?
Detection engineers monitor process creation events (Windows Event ID 4688 or Sysmon Event ID 1; Linux auditd EXECVE; macOS Endpoint Security) inspecting anomalous command line arguments, unusual parent-child process relationships (e.g. Office apps or web servers spawning Bcp.exe), and unexpected network connections.
What MITRE ATT&CK techniques does Bcp.exe map to?
Bcp.exe maps to MITRE ATT&CK technique(s): T1105. These techniques cover adversary actions across tactics such as Defense Evasion, Execution, Persistence, and Command and Control.
How can organizations mitigate and restrict Bcp.exe?
Mitigation strategies include implementing Application Control policies (AppLocker or Windows Defender Application Control - WDAC), enforcing Attack Surface Reduction (ASR) rules, configuring strict privilege separation (disallowing standard users from running sensitive switches), and alerting on execution from non-standard directories.
Other High-Traffic WINDOWS LOLBins
Certutil.exe is a command-line program installed as part of Certificate Services. Attackers frequently abuse it to download arbitrary files from remote URLs, encode/decode Base64 payloads to evade detection, and hash files.
Microsoft HTML Application (MSHTA) host executes .hta files and scripts embedded inside web pages. Attackers abuse mshta to execute malicious inline VBScript or JScript directly from the command line or remote HTTP servers.
The Rundll32 program loads and runs 32-bit and 64-bit Dynamic Link Libraries (DLLs). Threat actors use it to execute exported functions from arbitrary DLLs, run scriptlets, or execute code via MSHTML protocol handlers.
Background Intelligent Transfer Service (BITS) administrator tool manages asynchronous, throttled background transfers. Attackers use BITS to stage remote downloads that survive reboots and evade conventional network monitoring.