Get-mssDatabaseHealth 
# → Schreibt TXT + CSV in den OutputPath

Get-mssDatabaseHealth -SqlInstance "SQL01" | 
Where-Object { 
$_.Status -ne 'Online' -or 
$_.LastFullBackup -lt (Get-Date).AddDays(-2) -or 
$_.VlfCount -gt 1000 
} | Format-Table DatabaseName, Status, LastFullBackup, VlfCount

Get-mssOperationStatus

while ($true) { 
Clear-Host 
Get-mssOperationStatus -SqlInstance "SQL01" | 
Format-Table Database, OperationType, 
 PercentComplete, EstTimeRemaining -AutoSize 
Start-Sleep 15 
}

Get-mssAgentJobHistory -Status Failure ` 
-Since (Get-Date).AddDays(-1) | 
Format-Table JobName, RunDate, Message -AutoSize

Get-mssAgentJobHistory -JobName '*Backup*' -Status Failure ` 
-Since (Get-Date).AddDays(-1)

Get-mssDiskSpaceReport -SqlInstance "SQL01" -WarnThresholdPct 10 | 
Where-Object Status -eq 'Warning' | 
Sort-Object DaysUntilFull | 
Format-Table VolumeName, FreeGB, DaysUntilFull, Status -AutoSize

Get-mssAgHealthReport 
 
# Kritische Befunde herausfiltern: 
Get-mssAgHealthReport -SqlInstance "SQL01" | 
Where-Object OverallStatus -ne 'Healthy' | 
Format-Table AgName, ReplicaName, DbSyncState, RedoQueueMB

Invoke-mssAddDatabaseToAvailabilityGroup ` 
-AvailabilityGroup "AG_Prod" -Database "NeueDB"

Invoke-mssAddDatabaseToAvailabilityGroup ` 
-AvailabilityGroup "AG_Prod" -All

Sync-mssAgNode # erkennt Primary selbst 
Sync-mssAgNode -SqlInstance "SQL01" # explizit

Sync-mssAgNode -SqlInstance "SQL01" ` 
-ExcludeType Jobs,LinkedServers,Operators,Alerts

Repair-mssAlwaysOnDatabases

# Job erstellen (stündlich): 
New-mssAlwaysOnRepairJob -SqlInstance "SQL01"

Invoke-mssUserDatabaseBackup -All

Invoke-mssUserDatabaseBackup -SqlInstance "SQL01" ` 
-Database "SalesDB","InventoryDB"

Invoke-mssRestoreDatabase -SqlInstance "SQL01" ` 
-BackupFile "D:\Backup\SalesDB.bak" ` 
-DatabaseName "SalesDB"

$seq = @( 
"D:\Bak\SalesDB_Full.bak", 
"D:\Bak\SalesDB_Diff.bak", 
"D:\Bak\SalesDB_Log.trn" 
) 
Invoke-mssRestoreDatabase -SqlInstance "SQL01" ` 
-BackupFiles $seq -DatabaseName "SalesDB"

Invoke-mssRestoreDatabase -SqlInstance "SQL01" ` 
-BackupFile "D:\Bak\SalesDB.bak" ` 
-DatabaseName "SalesDB" -CreatePreRestoreBackup

Get-ChildItem "D:\Backup\*.bak" | ForEach-Object { 
$ok = Test-mssBackupIntegrity -SqlInstance "SQL01" ` 
-BackupPath $_.FullName 
[PSCustomObject]@{ File = $_.Name; Valid = $ok } 
} | Format-Table -AutoSize

Get-mssIndexFragmentation ` 
-Database "SalesDB" -MinFragmentationPercent 10 | 
Sort-Object FragmentationPercent -Descending | 
Format-Table TableName, IndexName, FragmentationPercent, Recommendation

# 1. Log sichern (bei Full Recovery): 
Backup-DbaDatabase -SqlInstance "SQL01" ` 
-Database "SalesDB" -Type Log -BackupDirectory "D:\Backup" 
 
# 2. Dann shrink: 
Invoke-mssLogShrink -Database "SalesDB" -ShrinkTargetPercent 20

Invoke-mssLogShrink -SqlInstance "SQL01" -All -WhatIf

Get-mssTempDbRecommendation -SqlInstance "SQL01"

Get-mssTempDbRecommendation -SqlInstance "SQL01" | 
Where-Object Status -ne 'OK' | 
Select-Object Status, Messages

# 1. Installieren 
Install-mssOlaMaintenanceSolution -SqlInstance "SQL01" 
 
# 2. Prüfen 
Test-mssOlaInstallation -SqlInstance "SQL01" 
 
# 3. Maintenance-Jobs anlegen 
New-mssOlaMaintenanceJobs -SqlInstance "SQL01" ` 
-ScheduleTime "23:00" -OperatorName "DBAs" 
 
# 4. System-DB-Backup-Job 
New-mssOlaSysDbBackupJob -SqlInstance "SQL01" ` 
-ScheduleTime "20:00" -OperatorName "DBAs"

$r = Invoke-mssSaObfuscation -SqlInstance "SQL01" 
# Kennwort SOFORT sicher aufbewahren: 
$r.GeneratedPassword | Out-File ` 
"C:\Secure\sa_pw_$(Get-Date -f 'yyyyMMdd').txt" 
Write-Host "Neuer Name: $($r.NewLoginName)"

"SQL01","SQL02","SQL03" | ForEach-Object { 
Invoke-mssSaObfuscation -SqlInstance $_ -ContinueOnError 
} | Select-Object SqlInstance, NewLoginName, Status | Format-Table

Get-mssSysadminAccounts -SqlInstance "SQL01" ` 
-ExcludeLogin "NT SERVICE\*","NT AUTHORITY\*","msssa" ` 
-ExcludeSysAccounts | 
Where-Object Status -in 'Unexpected','BuiltinAdmins' | 
Format-Table LoginName, LoginType, IsEnabled -AutoSize

Invoke-mssLoginAudit -SqlInstance "SQL01" ` 
-InactivityThresholdDays 90 ` 
-MaxPasswordAgeDays 180 ` 
-ExcludeLogin "NT SERVICE\*"

Invoke-mssLoginAudit -SqlInstance "SQL01" -CheckAdOrphans

$instances = Get-Content "C:\Admin\sql_instances.txt" 
Invoke-mssInstanceInventory ` 
-SqlInstance $instances -ContinueOnError 
# Dateien in: (Get-mssConfig -Key 'OutputPath')

Compare-mssServerConfiguration ` 
-SourceInstance "SQL01" -TargetInstance "SQL02" | 
Where-Object { $_.SourceValue -ne $_.TargetValue } | 
Format-Table Setting, SourceValue, TargetValue -AutoSize

Invoke-mssSetDatabaseRecoveryMode -All -RecoveryMode Full

Invoke-mssSetDatabaseRecoveryMode ` 
-Database "ArchiveDB" -RecoveryMode Simple

Find-mssDatabaseObject -SqlInstance "SQL01" ` 
-ObjectName "sp_GetOrders" | 
Format-Table Database, Schema, ObjectType, ObjectName

Find-mssDatabaseObject -SqlInstance "SQL01" ` 
-ObjectName "*" -SearchInDefinition ` 
-SearchText "OPENQUERY"