Invoke-sqmSetDatabaseRecoveryMode

SQL Config sqmSQLTool v1.8.2+

Changes the recovery mode of one or more user databases.

Examples

# Set all user databases to Full (without prompting)

# Set all user databases to Full (without prompting)
Invoke-sqmSetDatabaseRecoveryMode -All -RecoveryMode Full

# With confirmation prompt (passed to Set-DbaDbRecoveryModel)

# With confirmation prompt (passed to Set-DbaDbRecoveryModel)
Invoke-sqmSetDatabaseRecoveryMode -Database "SalesDB" -RecoveryMode Simple -Confirm