Get-VBRSQLDatabase not returning all DBs

PowerShell script exchange

Get-VBRSQLDatabase not returning all DBs

Veeam Logoby mmcverry » Wed May 10, 2017 1:27 pm

When I run Get-VBRSQLDatabase -ApplicationRestorePoint $restorepoints[0] where $restorepoints = Get-VBRApplicationRestorePoints -sql -name "myvmname", only a few of my SQL databases on that VM are returned in the results; the same is for any restore point in the $restorepoints array. However, when I perform an Application items restore from backup for the same VM from the Veeam Console, all of the SQL databases are listed in Veeam Explorer for SQL as expected and I'm able to perform restores from all of them. Why would all of the SQL databases for a restore point show up in Veeam Explorer for SQL but only some in Powershell? I ultimately want to use a Powershell script that will automatically restore the latest SQL backups for a handful of my databases off to a test location, which I can't currently do because Powershell is not pulling the SQL databases I'm wanting to do this for.

Support Case ID: 02151785
mmcverry
Lurker
 
Posts: 1
Liked: never
Joined: Wed Nov 30, 2016 7:29 pm
Full Name: Marie McVerry

Return to PowerShell



Who is online

Users browsing this forum: No registered users and 1 guest