Set-DPMAutoProtectIntent

Turns DPM auto-protection on or off for a SQL Server instance.

Syntax

Set-DPMAutoProtectIntent
   [-ProtectionGroup] <ProtectionGroup>
   [-SQLInstanceName] <String[]>
   [-AutoProtectIntent] <AutoProtectionIntent>
   [-AutoProtectCloudIntent] <Enable/Disable>
   [-ProductionServer] <ProductionServer>
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]

Description

The Set-DPMAutoProtectIntent cmdlet turns System Center 2016 - Data Protection Manager (DPM) auto-protection on or off for a Microsoft SQL Server data management software instance. When you use auto-protection for a SQL Server instance, DPM identifies and protects new databases added to that instance. To change the auto-protection setting, specify the SQL Server instance, the protection group that it belongs to, and a production server.

When you first add a SQL Server instance to a protection group, the DPM server enables auto-protection for that instance.

Examples

1:

Required Parameters

-AutoProtectCloudIntent

Specifies whether the commandlet turns Cloud auto-protection on or off. If set to Enable, all the datasources set to auto-protection to disk in the Protection Group will be auto-protected to cloud. If set to Disable, auto-protection to cloud will cease.

The acceptable values for this parameter are: Enable and Disable.

Type:AutoProtectCloudIntent
Position:4
Default value:Disable
Accept pipeline input:False
Accept wildcard characters:False
-AutoProtectIntent

Specifies whether the cmdlet turns auto-protection on or off.

The acceptable values for this parameter are: Enable and Disable.

Type:AutoProtectionIntent
Parameter Sets:Enable, Disable
Position:3
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-ProductionServer

Specifies a computer on which a DPM protection agent is installed.

Type:ProductionServer
Position:5
Default value:None
Accept pipeline input:True (ByValue)
Accept wildcard characters:False
-ProtectionGroup

Specifies a protection group on which this cmdlet operates. To obtain a ProtectionGroup object, use the Get-DPMProtectionGroup cmdlet.

Type:ProtectionGroup
Position:1
Default value:None
Accept pipeline input:True (ByValue)
Accept wildcard characters:False
-SQLInstanceName

Specifies an array of names of SQL Server instances.

Type:String[]
Position:2
Default value:None
Accept pipeline input:True (ByValue)
Accept wildcard characters:False

Optional Parameters

-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:False
Accept pipeline input:False
Accept wildcard characters:False
-WhatIf

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Type:SwitchParameter
Aliases:wi
Position:Named
Default value:False
Accept pipeline input:False
Accept wildcard characters:False