Skip to content

Latest commit

 

History

History
7 lines (7 loc) · 567 Bytes

06. Create APP_AWARE SQL.md

File metadata and controls

7 lines (7 loc) · 567 Bytes

Create a new AppAware SQL Policy using TSDM

$Credentials=New-PPDMcredentials -type OS -name sqldemoaccount -authmethod BASIC
$StorageSystem=Get-PPDMstorage_systems -Type DATA_DOMAIN_SYSTEM -Filter {name eq "ddve.home.labbuildr.com"}
$BackupSchedule=New-PPDMDatabaseBackupSchedule -daily -LogBackupUnit HOURLY -LogBackupInterval 1 -RetentionUnit DAY -RetentionInterval 3
New-PPDMSQLBackupPolicy -Schedule $BackupSchedule -Name MMSSQL_APPAWARE -AppAware -dbCID $credentials.id -StorageSystemID $StorageSystem.id -DataMover SDM -SizeSegmentation FSS