About Me

My photo
I am an MCSE in Data Management and Analytics, specializing in MS SQL Server, and an MCP in Azure. With over 19+ years of experience in the IT industry, I bring expertise in data management, Azure Cloud, Data Center Migration, Infrastructure Architecture planning, as well as Virtualization and automation. I have a deep passion for driving innovation through infrastructure automation, particularly using Terraform for efficient provisioning. If you're looking for guidance on automating your infrastructure or have questions about Azure, SQL Server, or cloud migration, feel free to reach out. I often write to capture my own experiences and insights for future reference, but I hope that sharing these experiences through my blog will help others on their journey as well. Thank you for reading!

Timeout occurred while installing Workload Backup extension on the virtual machine.\r\nRetry the operation. If the issue persists, please contact Microsoft support




"Message": "Timeout occurred while installing Workload Backup extension on the virtual machine.\r\nRetry the operation. If the issue persists, please contact Microsoft support.", "target": null, "details": null, "innerError": null



I was getting above error which says "Timeout occured while installing Workload Backup Extension on the Virtual Machine.
Refer this link - https://docs.microsoft.com/en-us/azure/backup/backup-azure-troubleshoot-vm-backup-fails-snapshot-timeout#the-vm-has-no-internet-access
In my case the My MSSQL Server VM in Azure was not on internet. So Backup extension were not getting install.



I deleted outbound policy which was restricting  internet access.

Then did discovery and this time i  did not get that error..

Discover SQL Server databases

Azure Backup discovers all databases on a SQL Server instance. You can protect the databases according to your backup requirements. Use the following procedure to identify the virtual machine that hosts the SQL databases. After you identify the virtual machine, Azure Backup installs a lightweight extension to discover the SQL Server databases.
  1. Sign in to your subscription in the Azure portal.
  2. On the left menu, select All services.
    Select All services
  3. In the All services dialog box, enter Recovery Services. As you type, your input filters the list of resources. Select Recovery Services vaults in the list.
    Enter and choose Recovery Services vaults
    The list of Recovery Services vaults in the subscription appears.
  4. In the list of Recovery Services vaults, select the vault to use to protect your SQL databases.
  5. On the Recovery Services vault dashboard, select Backup. The Backup Goal menu opens.
    Select Backup to open the Backup Goal menu
  6. On the Backup Goal menu, set Where is your workload running to the default: Azure.
  7. Expand the What do you want to back up drop-down list box and select SQL Server in Azure VM.
    Select SQL Server in Azure VM for the backup
    The Backup Goal menu displays two steps: Discover DBs in VMs and Configure Backup.
    Review the two Backup Goal steps
  8. Under Discover DBs in VMs, select Start Discovery to search for unprotected virtual machines in the subscription. It can take a while to search through all of the virtual machines. The search time depends on the number of unprotected virtual machines in the subscription.
    Backup is pending during search for DBs in VMs
    After an unprotected virtual machine is discovered, it appears in the list. Multiple virtual machines can have the same name. However, virtual machines with the same name belong to different resource groups. Unprotected virtual machines are listed by their virtual machine name and resource group. If an expected virtual machine isn't listed, see if that virtual machine's already protected to a vault.
  9. In the list of virtual machines, select the VM that has the SQL database to back up, and then select Discover DBs.
    Azure Backup discovers all SQL databases on the virtual machine. For information about what happens during the database discovery phase, see Background operations. After the SQL databases are discovered, you're ready to configure the backup job.

Background operations

When you use the Discover DBs tool, Azure Backup executes the following operations in the background:

  • Register the virtual machine with the Recovery Services vault for workload backup. All databases on the registered virtual machine can be backed up to this Recovery Services vault only.
  • Install the AzureBackupWindowsWorkload extension on the virtual machine. Back up of a SQL database is an agentless solution. The extension is installed on the virtual machine and no agent's installed on the SQL database.
  • Create the service account NT Service\AzureWLBackupPluginSvc on the virtual machine. All backup and restore operations use the service account. NT Service\AzureWLBackupPluginSvc needs SQL sysadmin permissions. All SQL Marketplace virtual machines come with the SqlIaaSExtension installed. The AzureBackupWindowsWorkload extension uses the SQLIaaSExtension to automatically get the required permissions. If your virtual machine doesn't have the SqlIaaSExtension installed, the Discover DB operation fails with the error message UserErrorSQLNoSysAdminMembership. To add the sysadmin permission for backup, follow the instructions in Set up Azure Backup permissions for non-Marketplace SQL VMs.




USE [master]
GO
CREATE LOGIN [NT SERVICE\AzureWLBackupPluginSvc] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
ALTER SERVER ROLE [sysadmin] ADD MEMBER [NT SERVICE\AzureWLBackupPluginSvc]
GO




Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)