PowerShell script exchange
Post Reply
mmcverry
Lurker
Posts: 1
Liked: never
Joined: Nov 30, 2016 7:29 pm
Full Name: Marie McVerry
Contact:

Get-VBRSQLDatabase not returning all DBs

Post by mmcverry » 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

inoisikoiski
Influencer
Posts: 17
Liked: never
Joined: Apr 12, 2019 9:55 am
Full Name: Inoi Visp
Contact:

Re: Get-VBRSQLDatabase not returning all DBs

Post by inoisikoiski » Apr 15, 2019 3:42 pm

hi, any news on this post?

veremin
Product Manager
Posts: 17070
Liked: 1475 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Get-VBRSQLDatabase not returning all DBs

Post by veremin » Apr 15, 2019 6:11 pm

This is obsolete cmdlet, now you should a new set of VESQL cmdlets. Can you tell what problem you experience while working with them? Thanks!

inoisikoiski
Influencer
Posts: 17
Liked: never
Joined: Apr 12, 2019 9:55 am
Full Name: Inoi Visp
Contact:

Re: Get-VBRSQLDatabase not returning all DBs

Post by inoisikoiski » Apr 23, 2019 1:56 pm

Thanks. managed to use VESQL.

veremin
Product Manager
Posts: 17070
Liked: 1475 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Get-VBRSQLDatabase not returning all DBs

Post by veremin » Apr 23, 2019 5:26 pm

Not sure whether I got it correctly. Can you tell me whether the issue persists with the provided set of VESQL cmdlets or not? Thanks!

inoisikoiski
Influencer
Posts: 17
Liked: never
Joined: Apr 12, 2019 9:55 am
Full Name: Inoi Visp
Contact:

Re: Get-VBRSQLDatabase not returning all DBs

Post by inoisikoiski » Apr 24, 2019 10:17 am

VESQL is giving me the entire set of databases. thanks

Post Reply

Who is online

Users browsing this forum: Brad.linch and 5 guests