Sync-sqmBackupExcludeTable - sqmSQLTool PowerShell Cmdlet Documentation

Sync-sqmBackupExcludeTable

Backup sqmSQLTool v1.8.2+

Creates and synchronises the backup exclude table in the master database.

Examples

# Synchronise on the local instance – user databases only

# Synchronise on the local instance – user databases only
Sync-sqmBackupExcludeTable

# Synchronise on a remote instance including system databases

# Synchronise on a remote instance including system databases
Sync-sqmBackupExcludeTable -SqlInstance "SQL01" -IncludeSystemDatabases

# Preview what would change without making any modifications

# Preview what would change without making any modifications
Sync-sqmBackupExcludeTable -SqlInstance "SQL01" -WhatIf

# Synchronise and verify that the audit history table and trigger are in place

# Synchronise and verify that the audit history table and trigger are in place
Sync-sqmBackupExcludeTable -SqlInstance "SQL01\INST1"