Restore current copy

[krisak8989]

Good afternoon!
Tell me how to restore the current copy of the SQL database using PS?

From the management console, I have the ability to restore the closest point. Via PS, the output of the Get-VBRRestorePoint command does not show the latest recovery points. Log transactions every 15 minutes

[Egor Yakovlev]

You need to use Start-VESQLRestoreSession, pick a database from mounted backup via Get-VESQLDatabase, find available restore interval Get-VESQLDatabaseRestoreInterval and restore via Restore-VESQLDatabase with -ToPointInTime parameter. Last but not least, stop mounted session via Stop-VESQLRestoreSession.

Check out Veeam Explorer for Microsoft SQL Powershell Reference Guide.

/Cheers!

[oleg.feoktistov]

Besides, use Get-VBRApplicationRestorePoint rather than Get-VBRRestorePoint to retrieve restore points with AAIP enabled.
Then, filter it by creation time and pass to Start-VESQLRestoreSession, like Egor wrote above.
Example:

Code: Select all

$date = (Get-Date).AddHours(-24)
$restorepoint = Get-VBRApplicationRestorePoint -SQL | where {$_.CreationTime -ge $date}
Start-VESQLRestoreSession -RestorePoint $restorepoint[-1]