SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
412 questions
Manually run a SQL Policy in Azure Backup
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 19%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Joe Correia
1
Reputation point
I created a SQL policy in Azure backup that performs a Full DB backup every night at 11PM and also runs Hourly Log Backups.
The target SQL server has 14 databases on it, and I want to manually run a backup of the entire server.
It seems like I have to go to backup instances and select each DB individually and launch a backup. #NotOptimal
Is there a way to launch the SQL policy itself?
SQL Server on Azure Virtual Machines
Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,490 questions
{count} votes
-
SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator2022-11-03T16:27:06.547+00:00 @Joe Correia Thank you for posting your question on Microsoft Q&A community platform!
It seems like you are performing Azure SQL database backup. Please confirm it is a SQL Server on Azure VM and using Azure backup for VM or Azure SQL Database for long term retention.
-
Joe Correia 1 Reputation point
2022-11-03T16:42:12.063+00:00 Yes it is a SQL Server running on an Azure VM.
The policy is for Azure Backup for "SQL in Azure VM" option. -
SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator
2022-11-04T04:24:41.793+00:00 Is there a way to launch the SQL policy itself?
As of today, there is no alternative.However, you don’t have to select each DB, on the list with their backup items, you can use the menu button to the right and click backup now. That way you don’t have to go into each item and just go down the list.
-
Joe Correia 1 Reputation point
2022-11-05T16:24:26.743+00:00 Yes clicking on the button to the right is the method I have been using.
Gets tiresome when the SQL server has 55 databases on it tho. ;) -
SadiqhAhmed-MSFT 49,326 Reputation points Microsoft Employee Moderator
2022-11-21T11:01:01.55+00:00 @Joe Correia Sorry for the delayed response.
If you are looking at doing backup manually quite frequently, employing a script to trigger backup could also be a good idea. Check this link - https://learn.microsoft.com/en-us/azure/backup/backup-azure-sql-backup-cli#trigger-an-on-demand-backup
Sign in to comment
Sign in to answer