Invoke-sqmConfigRollback - sqmSQLTool PowerShell Cmdlet Documentation

Invoke-sqmConfigRollback

Inventory sqmSQLTool v1.8.2+

Restores SQL Server configuration from a previously exported snapshot.

Examples

# Preview what would be restored

# Preview what would be restored
Invoke-sqmConfigRollback -SqlInstance "SQL01" `
  -SnapshotPath "C:\Snapshots\SQL01_MSSQLSERVER_20260602_143022.json" `
  -WhatIf

# Apply rollback (with confirmation)

# Apply rollback (with confirmation)
Invoke-sqmConfigRollback -SqlInstance "SQL01" `
  -SnapshotPath "C:\Snapshots\SQL01_MSSQLSERVER_20260602_143022.json"

# Force rollback without confirmation

# Force rollback without confirmation
Invoke-sqmConfigRollback -SqlInstance "SQL01" `
  -SnapshotPath "C:\Snapshots\SQL01_MSSQLSERVER_20260602_143022.json" `
  -Force

# Rollback only sp_configure settings

# Rollback only sp_configure settings
Invoke-sqmConfigRollback -SqlInstance "SQL01" `
  -SnapshotPath "C:\Snapshots\SQL01_MSSQLSERVER_20260602_143022.json" `
  -Category 'SpConfigure' `
  -Force

← Previous Command

Get-sqmLinkedServerUsage

Next Command →

Invoke-sqmInstanceInventory