SYNOPSIS
Sets SQL Instance properties
SYNTAX
NoSLA_Changes (Default)
Copy Set-RubrikSQLInstance [[-id] <String>] [-LogBackupFrequencyInSeconds <Int32>] [-LogRetentionHours <Int32>]
[-CopyOnly] [-Server <String>] [-api <String>] [-WhatIf] [-Confirm] [<CommonParameters>]
SLA_Inherit
Copy Set-RubrikSQLInstance [[-id] <String>] [-LogBackupFrequencyInSeconds <Int32>] [-LogRetentionHours <Int32>]
[-CopyOnly] [-Inherit] [-Server <String>] [-api <String>] [-WhatIf] [-Confirm] [<CommonParameters>]
SLA_Unprotected
Copy Set-RubrikSQLInstance [[-id] <String>] [-LogBackupFrequencyInSeconds <Int32>] [-LogRetentionHours <Int32>]
[-CopyOnly] [-DoNotProtect] [-Server <String>] [-api <String>] [-WhatIf] [-Confirm] [<CommonParameters>]
SLA_Explicit
Copy Set-RubrikSQLInstance [[-id] <String>] [-LogBackupFrequencyInSeconds <Int32>] [-LogRetentionHours <Int32>]
[-CopyOnly] [-SLAID <String>] [-SLA <String>] [-Server <String>] [-api <String>] [-WhatIf] [-Confirm]
[<CommonParameters>]
DESCRIPTION
The Set-RubrikSQLInstance cmdlet is used to update certain settings for a Rubrik SQL instance.
EXAMPLES
EXAMPLE 1
Copy Set-RubrikSQLInstance
EXAMPLE 2
Copy Get-RubrikSQLInstance -Hostname RFITZHUGH-SQL | Set-RubrikSQLInstance -Inherit -Verbose -CopyOnly
Will update the SLA policy for the RFITZHUGH SQL host to inherit and setting copyOnly to true while displaying verbose information in the console
PARAMETERS
-id
Rubrik's database id value
Copy Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-LogBackupFrequencyInSeconds
Number of seconds between log backups if db s are in FULL or BULK_LOGGED NOTE: Default of -1 is used to get around ints defaulting as 0
Copy Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: -1
Accept pipeline input: False
Accept wildcard characters: False
-LogRetentionHours
Number of hours backups will be retained in Rubrik NOTE: Default of -1 is used to get around ints defaulting as 0
Copy Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: -1
Accept pipeline input: False
Accept wildcard characters: False
-CopyOnly
Boolean declaration for copy only backups on the instance.
Copy Type: SwitchParameter
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False
-SLAID
SLA Domain ID for the database
Copy Type: String
Parameter Sets: SLA_Explicit
Aliases: ConfiguredSlaDomainId
Required: False
Position: Named
Default value: (Test-RubrikSLA -SLA $SLA -Inherit $Inherit -DoNotProtect $DoNotProtect -Mandatory:$false)
Accept pipeline input: False
Accept wildcard characters: False
-SLA
The SLA Domain name in Rubrik
Copy Type: String
Parameter Sets: SLA_Explicit
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-DoNotProtect
Removes the SLA Domain assignment
Copy Type: SwitchParameter
Parameter Sets: SLA_Unprotected
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False
-Inherit
Inherits the SLA Domain assignment from a parent object
Copy Type: SwitchParameter
Parameter Sets: SLA_Inherit
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False
-Server
Rubrik server IP or FQDN
Copy Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: $global:RubrikConnection.server
Accept pipeline input: False
Accept wildcard characters: False
-api
API version
Copy Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: $global:RubrikConnection.api
Accept pipeline input: False
Accept wildcard characters: False
-WhatIf
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Copy Type: SwitchParameter
Parameter Sets: (All)
Aliases: wi
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-Confirm
Prompts you for confirmation before running the cmdlet.
Copy Type: SwitchParameter
Parameter Sets: (All)
Aliases: cf
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters .
INPUTS
OUTPUTS
NOTES
Written by Mike Fal for community usage Twitter: @Mike_Fal GitHub: MikeFal
RELATED LINKS
https://rubrik.gitbook.io/rubrik-sdk-for-powershell/command-documentation/reference/set-rubriksqlinstance