Skip to content

Latest commit

 

History

History
7 lines (7 loc) · 496 Bytes

08. Create_SelfService_SQL.md

File metadata and controls

7 lines (7 loc) · 496 Bytes

Create a SelfServicee 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  -Name MSSQL_SELF -RetentionUnit DAY -RetentionInterval 1 -StorageSystemID $StorageSystem.id