dfirhub

MSSQLErrorLog

Logsv1

Author: Troy Larson

description

MS SQL ErrorLogs

paths

2 paths
› paths use Windows environment syntax

collection commands 

# PowerShell Artifact Collection Script
# Target: MSSQLErrorLog
# Run as Administrator

#Requires -RunAsAdministrator

$ErrorActionPreference = "SilentlyContinue"
$DestBase = "D:\Evidence"

# Function to handle artifact collection with robocopy
function Collect-Artifact {
    param (
        [string]$SourceDir,
        [string]$FolderName,
        [string]$FileMask = "*"
    )
    $FullDest = Join-Path -Path $DestBase -ChildPath $FolderName
    robocopy "$SourceDir" "$FullDest" "$FileMask" /E /COPY:DAT /R:0 /W:0 /NP /NFL /NDL /NJH /NJS | Out-Null
}

# 1. MS SQL Errorlog
Collect-Artifact -SourceDir "C:\Program Files\Microsoft SQL Server\*\MSSQL\LOG\" -FileMask "ERRORLOG" -FolderName "MS_SQL_Errorlog"

# 2. MS SQL Errorlogs
Collect-Artifact -SourceDir "C:\Program Files\Microsoft SQL Server\*\MSSQL\LOG\" -FileMask "ERRORLOG.*" -FolderName "MS_SQL_Errorlogs"

Write-Host "Collection complete!" -ForegroundColor Green

› Save as .ps1 and run as Administrator. Use: powershell -ExecutionPolicy Bypass -File script.ps1

included in collections

ServerTriage WebServers