Skip to content

Latest commit

 

History

History
7 lines (7 loc) · 511 Bytes

07. Create Centralized_SQL.md

File metadata and controls

7 lines (7 loc) · 511 Bytes

Create a new Centralized SQL Policy

$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 MSSQL_CENTRAL  -dbCID $credentials.id -StorageSystemID $StorageSystem.id