Set-DPMAutoProtectIntent

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

Syntax

Set-DPMAutoProtectIntent [-ProtectionGroup] <ProtectionGroup> [-SQLInstanceName] <String[]>
 [-AutoProtectIntent] <AutoProtectionIntent> [-AutoProtectCloudIntent] <AutoProtectCloudIntent>
 [-ProductionServer] <ProductionServer> [-Confirm] [-WhatIf] [<CommonParameters>]
Set-DPMAutoProtectIntent [-ProtectionGroup] <ProtectionGroup> [-SQLInstanceName] <String[]>
 [-AutoProtectIntent] <AutoProtectionIntent> [-AutoProtectCloudIntent] <AutoProtectCloudIntent>
 [-ProductionServer] <ProductionServer> [-Confirm] [-WhatIf] [<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:

Parameters

-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
Required:True
Position:3
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-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
Required:True
Position:4
Default value:Disable
Accept pipeline input:False
Accept wildcard characters:False
-ProductionServer

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

Type:ProductionServer
Required:True
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
Required:True
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[]
Required:True
Position:2
Default value:None
Accept pipeline input:True (ByValue)
Accept wildcard characters:False
-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Aliases:cf
Required:False
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
Required:False
Position:Named
Default value:False
Accept pipeline input:False
Accept wildcard characters:False