powershell command for sql log backup

Question

Siva 736

Hi Team,

Do we have any command for list the azure for sql vm log backup status. I have for list the full backup.

$Jobs = Get-AzRecoveryServicesBackupJob -VaultId $vault.ID -From (Get-Date).AddDays(-1).ToUniversalTime() -BackupManagementType AzureWorkload

this is listing all sql full backup, but not sql log backup. can you please check and assist if you have any commands.

Sadiqh Ahmed 49,571 Reputation points Microsoft External Staff Moderator

2022-01-13T10:35:21.333+00:00

@Siva Log jobs are very frequent and hence they are not recorded as jobs. If you could provide more details about your final goal (like latest log based recovery point?) then we can check and let you know about the possibilities.
Siva 736 Reputation points

2022-01-13T11:36:55.093+00:00

Hi SadiqhAhmed-MSFT,

I need this for report to client. I am getting all workload backup history via ps, but not log backup history.

Thanks

1 answer

Sadiqh Ahmed 49,571 Reputation points Microsoft External Staff Moderator

2022-01-13T10:35:21.333+00:00

@Siva Log jobs are very frequent and hence they are not recorded as jobs. If you could provide more details about your final goal (like latest log based recovery point?) then we can check and let you know about the possibilities.
Siva 736 Reputation points

2022-01-13T11:36:55.093+00:00

Hi SadiqhAhmed-MSFT,

I need this for report to client. I am getting all workload backup history via ps, but not log backup history.

Thanks

Answer 1

Sadiqh Ahmed 49,571 Microsoft External Staff Moderator

@Siva You cannot retrieve log backup records from Azure APIs (since they happen every 15 mins) but you can get those records using Log Analytics. It is detailed here - https://learn.microsoft.com/en-us/azure/backup/backup-azure-monitoring-use-azuremonitor

Are you looking for EVERY log backup record for your clients?
May be latest recovery point is better.

----------------------------------------------------------------------------------------------------------------------

If the response helped, do "Accept Answer" and up-vote it

Siva 736 Reputation points

2022-01-13T16:07:31.637+00:00

Hi SadiqhAhmed-MSFT,

Yes, Do we have any commands for this?
Sadiqh Ahmed 49,571 Reputation points Microsoft External Staff Moderator

2022-01-13T17:05:09.29+00:00

AFAIK, there is 'No' PS cmdlet.