RESTful knowledge exchange
Post Reply
skjaerhus
Lurker
Posts: 2
Liked: 2 times
Joined: May 10, 2021 9:55 am
Full Name: Søren Kjærhus
Contact:

SQL Transaction log details through Rest API

Post by skjaerhus » 1 person likes this post

Hi,

Is it possible to query details about the SQL log shipping jobs through the Rest API?
I cant seem to find anything relating to the log shipping jobs in the API's.

I would basically like to list all SQL instances part of the logshipping jobs, and the restore points per database within them.
The problem being that there's no reports covering that in the products we have today, Please correct me if im wrong. :) : B&R Enterprise, Enterprise Manager, Licensed SCOM Management Pack.

When doing a restore of a SQL database in Enterprise manager that's covered by a log shipping job I can see that enterprise manager has the up to date information about the last log shipping task when looking at "point in time" restore time available.
oleg.feoktistov
Veeam Software
Posts: 1912
Liked: 635 times
Joined: Sep 25, 2019 10:32 am
Full Name: Oleg Feoktistov
Contact:

Re: SQL Transaction log details through Rest API

Post by oleg.feoktistov »

Hi,

As of now, log shipping jobs are not exposed neither through EM nor VBR REST API.
You can still get them through Powershell, but it's a question for different subforum.

Thanks,
Oleg
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests