Home / Commands / New-sqmBackupMaintenanceJob
New-sqmBackupMaintenanceJob
Backup sqmSQLTool v1.8.2+
Creates a SQL Agent job with two steps that implement the full dynamic backup maintenance workflow.

Examples

# Weekly FULL backup Sunday 20:00 with all features
# Weekly FULL backup Sunday 20:00 with all features
	New-sqmBackupMaintenanceJob -SqlInstance "SQL01" -BackupType FULL `
	    -UseExcludeTable -CheckPreferredReplica `
	    -MailTo "dba@company.com" -MailProfile "DBA-Mail"
# Daily DIFF backup with exclude table
# Daily DIFF backup with exclude table
	New-sqmBackupMaintenanceJob -SqlInstance "SQL01" -BackupType DIFF `
	    -UseExcludeTable -ScheduleTime "22:00"
# LOG backup every 15 minutes
# LOG backup every 15 minutes
	New-sqmBackupMaintenanceJob -SqlInstance "SQL01" -BackupType LOG `
	    -ScheduleIntervalMinutes 15 -UseExcludeTable
# Replace existing job
# Replace existing job
	New-sqmBackupMaintenanceJob -SqlInstance "SQL01" -BackupType FULL -Update
← Previous Command
Invoke-sqmUserDatabaseBackup
Next Command →
New-sqmOlaSysDbBackupJob