SQL PaaS DB Server | Backup Reports

Prasenna Kannan 436

Hello,

I wanted to push all the backup reports to a log analytic workspace for Azure SQL PaaS databases.

I'm able to set SQL auditing and collect database events. However, back reports does not ship with those logging events.

Is there a possibility to get the backup reports of Azure SQL PaaS to a log analytic workspace?

Thanks,

Navtej Singh Saini 4,216 Reputation points Microsoft Employee

2020-12-01T22:28:03.117+00:00

@Prasenna Kannan

We are checking this and will get back to you.

Thanks
Navtej S
Navtej Singh Saini 4,216 Reputation points Microsoft Employee

2020-12-02T12:17:01.913+00:00

@Prasenna Kannan

Please convey which backup reports you are implying to and how you have set it in the Log Analytics. Provide a screenshot if you can.

There may not be out of the box solution but we can definitely check with our Product team. And they will be asking for the above questions. So please help with the same for moving forward with this.

Thanks
Navtej S
Prasenna Kannan 436 Reputation points

2020-12-03T02:24:38.007+00:00

@Navtej Singh Saini

In the screenshot attached, I can see the backup data of Azure SQL PaaS DB server. I understand these backups are taken care by MS. But, my requirement is to get the backup data to log analytics so that I can show that I can bring in the dashboard using a query.

My objective is to bring the backup report to a dashboard.
Navtej Singh Saini 4,216 Reputation points Microsoft Employee

2020-12-03T23:00:19.413+00:00

@Prasenna Kannan We are checking this further and will get back to you.

Accepted answer

1 additional answer