Public/Get-RubrikDatabaseRecoveryPoint.ps1
|
#Requires -Version 3 function Get-RubrikDatabaseRecoveryPoint { <# .SYNOPSIS Retrieves a date time combination either from Rubrik API calls or with entered information that is formated for use by other Rubrik cmdlets .DESCRIPTION The Get-RubrikDatabaseRecoveryPoint cmdlet is used to pull date time combination from either Get-RubrikDatabase or Get-RubrikSnapshot based on a database ID. When we pull the value from those cmdlets, we will use that in Export-RubrikDatabase, New-RubrikDatabaseMount, Restore-RubrikDatabase. We will also pass in a time to get back a date time combination or an exact time. ALl results will be returned back in UTC so that the cmdlets can properly perform their functions. .PARAMETER RubrikDatabaseID Provide an ID of a database that is returned back from Get-RubrikDatabase .PARAMETER Latest A time to which the database should be restored to. latest: This will tell Rubrik to export the database to the latest recovery point Rubrik knows about This will include the last full and any logs to get to the latest recovery point .PARAMETER Latest A time to which the database should be restored to. last full: This will tell Rubrik to restore back to the last full backup it has .PARAMETER RestoreTime A time to which the database should be restored to. Format: (HH:MM:SS.mmm) at the point in time specified within the last 24 hours Format: Any valid <value> that PS Get-Date supports in: "Get-Date -Date <Value>" Example: "2018-08-01T02:00:00.000Z" restores back to 2AM on August 1, 2018 UTC. .NOTES Written by Chris Lumnah for community usage Twitter: @lumnah GitHub: clumnah .LINK https://rubrik.gitbook.io/rubrik-sdk-for-powershell/command-documentation/reference/get-rubrikdatabaserecoverypoint .EXAMPLE Get-RubrikDatabaseRecoveryPoint -id "MssqlDatabase:::10dd9979-fdcb-4dc2-b212-20efffd39102" -Latest This will return back a date time combination that prepresents the latest recovery point known to Rubrik about this database. This will include the last snapshot and any transaction log backup taken since that last snapshot was taken. .EXAMPLE Get-RubrikDatabaseRecoveryPoint -id "MssqlDatabase:::10dd9979-fdcb-4dc2-b212-20efffd39102" -LastFull This will return back a date time combination that prepresents the recovery point known to Rubrik about this database based on the most recent snapshot taken. .EXAMPLE Get-RubrikDatabaseRecoveryPoint -id "MssqlDatabase:::10dd9979-fdcb-4dc2-b212-20efffd39102" -RestoreTime 02:00:00 This will return back a date time combination that represents todays date at 2am, but converted to UTC. The time entered into the RestoreTime field will be in local time. .EXAMPLE Get-RubrikDatabaseRecoveryPoint -id "MssqlDatabase:::10dd9979-fdcb-4dc2-b212-20efffd39102" -RestoreTime "2019-10-19 20:00:00" This will return back a date time combination that represents the local date time value entered into the RestoreTme field, converted to UTC. #> param( # Rubrik's database id value [Parameter( Position = 0, Mandatory = $true, ValueFromPipelineByPropertyName = $true)] [ValidateNotNullOrEmpty()] [string]$id, [Parameter(ParameterSetName = 'Latest')] [switch]$Latest, [Parameter(ParameterSetName = 'LastFull')] [switch]$LastFull, [Parameter(ParameterSetName = 'RestoreTime')] [datetime]$RestoreTime ) if ($PSBoundParameters.ContainsKey('Latest')) { $LatestRecoveryPoint = (Get-RubrikDatabase -id $id ).latestRecoveryPoint $RecoveryDateTime = $LatestRecoveryPoint } if ($PSBoundParameters.ContainsKey('LastFull')) { $RubrikSnapshot = Get-RubrikSnapshot -id $id | Sort-Object date -Descending | Select-object -First 1 $RecoveryDateTime = $RubrikSnapshot.date } if ($PSBoundParameters.ContainsKey('RestoreTime')) { $RawRestoreDate = (get-date -Date $RestoreTime) Write-Verbose ("RawRestoreDate is: $RawRestoreDate") $Now = (Get-Date).ToUniversalTime() if ($RawRestoreDate -ge $Now) { $RecoveryDateTime = $RawRestoreDate.AddDays(-1) Write-Verbose ("RecoveryDateTime is: $RecoveryDateTime") } else { $RecoveryDateTime = $RawRestoreDate } $RecoveryDateTime = $RecoveryDateTime.ToUniversalTime().ToString('yyyy-MM-ddTHH:mm:ss.fffZ') } return $RecoveryDateTime } |