Home / Commands / Export-sqmServerConfiguration
Export-sqmServerConfiguration
Inventory sqmSQLTool v1.8.2+
Exports all SQL Server configuration settings to a JSON snapshot file.

Examples

# Create a snapshot before making configuration changes
# Create a snapshot before making configuration changes
$snap = Export-sqmServerConfiguration -SqlInstance "SQL01" -Label "before MaxMemory change"
Write-Host "Snapshot saved to: $($snap.SnapshotPath)"
# Export with custom output path
# Export with custom output path
Export-sqmServerConfiguration -SqlInstance "SQL01" `
  -OutputPath "C:\Backups\SQLSnapshots" `
  -Label "production-baseline"
# Full export including databases
# Full export including databases
Export-sqmServerConfiguration -SqlInstance "SQL01" `
  -IncludeDatabases `
  -Label "complete-inventory"
← Previous Command
Set-sqmConfig
Next Command →
Find-sqmDatabaseObject