exports/Restore-CVSQLDatabase.ps1
|
# ---------------------------------------------------------------------------------- # # Copyright Microsoft Corporation # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. # You may obtain a copy of the License at # http://www.apache.org/licenses/LICENSE-2.0 # Unless required by applicable law or agreed to in writing, software # distributed under the License is distributed on an "AS IS" BASIS, # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. # See the License for the specific language governing permissions and # limitations under the License. # ---------------------------------------------------------------------------------- <# .Synopsis Method to submit SQL database in-place or out-of-place restore job. .Description Method to submit SQL database in-place or out-of-place restore job. .Example PS C:\> {{ Add code here }} {{ Add output here }} .Example PS C:\> {{ Add code here }} {{ Add output here }} .Inputs System.Object .Outputs System.String .Link https://docs.microsoft.com/en-us/powershell/module/commvaultpowershell/restore-cvsqldatabase #> function Restore-CVSQLDatabase { [OutputType([System.String])] [CmdletBinding(DefaultParameterSetName='ByName', PositionalBinding=$false, SupportsShouldProcess, ConfirmImpact='Medium')] param( [Parameter(ParameterSetName='ByName', Mandatory)] [Commvault.Powershell.Category('Body')] [System.String] # Specify the database files to be restored by database Name. ${Name}, [Parameter()] [Commvault.Powershell.Category('Body')] [System.Int32] # Specify the database files to be restored by PointInTime. ${PointInTime}, [Parameter()] [Commvault.Powershell.Category('Body')] [System.Int32] # Specify the database files to be restored by the CopyPrecedence applicable to your environment. ${CopyPrecedence}, [Parameter()] [Commvault.Powershell.Category('Body')] [System.Management.Automation.SwitchParameter] # Switch to initiate an out-of-place restore. ${OutofPlace}, [Parameter()] [Commvault.Powershell.Category('Body')] [System.Management.Automation.SwitchParameter] # Switch to control OverwriteExisting of the database files. ${OverwriteExisting}, [Parameter()] [Commvault.Powershell.Category('Body')] [System.Management.Automation.SwitchParameter] # Switch to Force override of default 'WhatIf' confirmation behavior. ${Force}, [Parameter(ParameterSetName='ByObject', Mandatory, ValueFromPipeline, ValueFromPipelineByPropertyName)] [Commvault.Powershell.Category('Body')] [System.Object] # Specify the database files to be restored by piping DatabaseObject. ${DatabaseObject} ) begin { try { $outBuffer = $null if ($PSBoundParameters.TryGetValue('OutBuffer', [ref]$outBuffer)) { $PSBoundParameters['OutBuffer'] = 1 } $parameterSet = $PSCmdlet.ParameterSetName $mapping = @{ ByName = 'CommvaultPowershell.custom\Restore-CVSQLDatabase'; ByObject = 'CommvaultPowershell.custom\Restore-CVSQLDatabase'; } $wrappedCmd = $ExecutionContext.InvokeCommand.GetCommand(($mapping[$parameterSet]), [System.Management.Automation.CommandTypes]::Cmdlet) $scriptCmd = {& $wrappedCmd @PSBoundParameters} $steppablePipeline = $scriptCmd.GetSteppablePipeline($MyInvocation.CommandOrigin) $steppablePipeline.Begin($PSCmdlet) } catch { throw } } process { try { $steppablePipeline.Process($_) } catch { throw } } end { try { $steppablePipeline.End() } catch { throw } } } |