question

PrasennaKannan-4219 avatar image
0 Votes"
PrasennaKannan-4219 asked ws3d answered

SQL PaaS DB Server | Backup Reports

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,

azure-sql-database
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@PrasennaKannan-4219

We are checking this and will get back to you.

Thanks
Navtej S

1 Vote 1 ·

@PrasennaKannan-4219

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

0 Votes 0 ·

@NavtejSaini-MSFT

44535-ms-screenshot.jpg




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.

0 Votes 0 ·
ms-screenshot.jpg (201.4 KiB)

@PrasennaKannan-4219 We are checking this further and will get back to you.

1 Vote 1 ·
NavtejSaini-MSFT avatar image
1 Vote"
NavtejSaini-MSFT answered PrasennaKannan-4219 commented

@PrasennaKannan-4219

We did check and verify this with our Product team and they have conveyed that we do not ship the LTR backup information to log analytics.

Please raise this on Azure SQL feedback channel and PG team has direct access to this and they will check and prioritize the feature.

Please let us know if you need any other help.

Thanks
Navtej S


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@PrasennaKannan-4219
Please let us know if you need further help regarding this.

Navtej S

0 Votes 0 ·

@NavtejSaini-MSFT - Thank you!

0 Votes 0 ·
ws3d avatar image
0 Votes"
ws3d answered

Has there been any movement on moving the LTR backup information to log analytics? Or can the backup information be found through Azure modules in PowerShell?
Thank you.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.