Need to publish last mssql daily

[kmbstech]

I need to to publish a mssql backup to a dev server daily so data can be collected from it. How would I select the last backup session ? I plan on using Publish-VESQLDatabase to publish but have no idea how to get the backup that I need.

[oleg.feoktistov]

Hi,

You could get application restore points, filter the one you need by creation time, start a restore session, get database and finally publish it. For examplre:

Code: Select all

$sql = Get-VBRApplicationRestorePoint -SQL
$sqlLast = $sql | sort -Property CreationTime -Descending | select -First 1
$session = Start-VESQLRestoreSession -RestorePoint $sqlLast
$database = Get-VESQLDatabase -Session $session
Restore-VESQLDatabase # ... etc.

Thanks,
Oleg

[kmbstech]

Thanks