Azure-docs: PowerShell Setup

[Ayanmullick]

How do I set this up with PowerShell? Could someone share how-to thru Invoke-RestMethod if cmdlets not ready?

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: a0e26853-8b25-7b94-ce79-c47853ca18aa
• Version Independent ID: 39636d49-dc5e-62c6-6bcb-70616cff369e
• Content: Backup and Restore for SQL Server in Azure VMs
• Content Source: articles/virtual-machines/windows/sql/virtual-machines-windows-sql-backup-recovery.md
• Service: virtual-machines-sql
• GitHub Login: @MikeRayMSFT
• Microsoft Alias: mikeray

[mimckitt]

Thanks for the question! We are investigating and will update you shortly.

[Karishma-Tiwari-MSFT]

@Ayanmullick Here is the document to configure Automated Backup using PowerShell.

[Ayanmullick]

That link is for the Azure VM SQL extension and not for the Azure backup vault.
@AnuragMehrotra

[Karishma-Tiwari-MSFT]

@Ayanmullick Can you please elaborate a little more on what are you looking for?

The above link that I shared has PowerShell commands to configure automated backup as well.
Refer to https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-automated-backup-v2#configure-automated-backup-v2
and you will find New-AzureRmVMSqlServerAutoBackupConfig command to enable and configure the Automated Backup v2 settings to store backups

Is it not what you are looking for? Let me know. Thanks.

[Ayanmullick]

I'm looking for the Powershell guide to do SQL backup thru Azure Backup Vault. The above link doesn't use the Azure Backup Vault.

@AnuragMehrotra

[Karishma-Tiwari-MSFT]

@MikeRayMSFT @AnuragMehrotra Can either of you please share your insights on this? Thanks :)
CC: @Adam-Smith-MSFT

[AnuragMehrotra]

@Ayanmullick We are working on adding PowerShell support and targeting for H1CY19. @pvrk is working on the feature.

[Ayanmullick]

@pvrk could you share a guide using the Invoke-RestMethod cmdlet in the meantime?

[pvrk]

@Ayanmullick: Are you looking at any one particular scenario or for all operations?

[Ayanmullick]

@pvrk Just the plain setup as shown in the video so one can script the Backup setup and restore instead of having to do manually each time.

[mimckitt]

@Ayanmullick any update on this?

[Ayanmullick]

@MicahMcKittrick-MSFT, I'm awaiting an update from @pvrk

[mimckitt]

@Ayanmullick ah yes sorry. I meant to @ them instead... oops :)

[pvrk]

@Ayanmullick : I am preparing a word document first. Can you please share your email ID so that I can share? This is not ready to be published in Github yet :-)

[Ayanmullick]

@pvrk , my email is on my profile.

[mimckitt]

Thanks @Ayanmullick. I will close this out as @pvrk can find your email and continue with you offline.

[Warent2454]

@pvrk i'm looking to do an automatic restore with powershell. Is it possible to share the restmethod with me aswell?

Thanks

[pvrk]

@Warent2454 : We are planning to make powershell commands for SQL backup and restore by Feb mid-end. Would that work for you? It's better to use PS commands since they handle lot of validations at the client end before proceeding to call REST APIs.

[Warent2454]

@pvrk Is it possible that i already have access to the powershell commands in preview? we have a perfect use case for this. Thanks!