Stop and start an instance - Azure SQL Managed Instance

To stop and start your instance with PowerShell, you can install Azure PowerShell, or use the Azure Cloud Shell.

When Cloud Shell opens, verify that PowerShell is selected for your environment. Subsequent sessions use Azure CLI in a PowerShell environment. Select Copy to copy the blocks of code, paste it into the Cloud Shell, and press Enter to run it.

Once PowerShell or Cloud Shell is launched, define the parameters:

$SubscriptionId = "<Subscription-ID>"
$SqlMIName = "<SQL-MI-name>"
$RgName = "<SQL-MI-resource-group>"

# Login-AzAccount
Select-AzSubscription -SubscriptionName $SubscriptionID

To stop and start your instance with the Azure CLI, you can install Azure CLI, or use the Azure Cloud Shell.

When Cloud Shell opens, verify that Bash is selected for your environment. Subsequent sessions use Azure CLI in a Bash environment. Select Copy to copy the blocks of code, paste it into the Cloud Shell, and press Enter to run it.

Cloud Shell is automatically authenticated under the initial account signed-in with. Use the following script to sign in using a different subscription, replacing <Subscription ID> with your Azure Subscription ID.

subscription="<Subscription-ID>"
instanceName="<SQL-MI-name>"
resourceGroupName="<SQL-MI-resource-group>"

az account set -s $subscription # ...or use 'az login'

For more information, see set active subscription or log in interactively.

To stop your SQL managed instance by using the Azure portal, go to the Overview page of your instance, and then select the Stop button.

If your instance is already stopped, the Stop button is unavailable.

To stop your SQL managed instance with PowerShell, use Stop-AzSqlInstance, such as the following sample script:

Stop-AzSqlInstance -Name $SqlMIName -ResourceGroupName $RgName

To stop your SQL managed instance with the Azure CLI, use az sql mi stop, such as the following sample script:

az sql mi stop --mi $instanceName -g $resourceGroupName

Stop the SQL managed instance by calling the Managed Instances - Stop API:

POST
https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/
providers/Microsoft.Sql/managedInstances/{managedInstanceName}/stop?api-version=2021-08-01-preview

After your SQL managed instance is stopped, to start it by using the Azure portal, go to the Overview page of your instance, and then select the Start button.

If your instance is already started, the Start button is unavailable.

To start your SQL managed instance with PowerShell, use Start-AzSqlInstance, such as the following sample script:

Start-AzSqlInstance -Name $SqlMIName -ResourceGroupName $RgName

To start your SQL managed instance with the Azure CLI, use az sql mi start, such as the following sample script:

az sql mi start --mi $instanceName -g $resourceGroupName

Start the SQL managed instance by calling the Managed Instances - Start API:

https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/
providers/Microsoft.Sql/managedInstances/{managedInstanceName}/start?api-version=2021-08-01-preview

To manage a stop and start schedule by using the Azure portal, go to your instance, and then select Start/Stop Schedule in the resource menu.

On the Start/Stop Schedule pane, you can:

• View existing schedules.
• Specify the time zone of your scheduled events in the Time zone dropdown list.
• Create a new schedule by selecting Create a schedule item.
• Modify an existing schedule by selecting the pencil icon.
• Delete an existing schedule by selecting the trash can icon.

Create schedule

To create a schedule to stop and start a SQL managed instance with PowerShell, use New-AzSqlInstanceStartStopSchedule and New-AzSqlInstanceScheduleItem, such as the following sample script:

$newSchedule = [System.Collections.ArrayList]::new()

$newScheduleMonday = New-AzSqlInstanceScheduleItem -StartDay Monday -StopDay Monday -StartTime "09:00" -StopTime "17:00"
$newSchedule.add($newScheduleMonday)

$newScheduleTuesday = New-AzSqlInstanceScheduleItem -StartDay Tuesday -StopDay Tuesday -StartTime "09:00" -StopTime "17:00"
$newSchedule.add($newScheduleTuesday)

$newScheduleWednesday = New-AzSqlInstanceScheduleItem -StartDay Wednesday -StopDay Wednesday -StartTime "07:00" -StopTime "19:00"
$newSchedule.add($newScheduleWednesday)

$newScheduleThursday = New-AzSqlInstanceScheduleItem -StartDay Thursday -StopDay Thursday -StartTime "09:00" -StopTime "17:00"
$newSchedule.add($newScheduleThursday)

$newScheduleFriday = New-AzSqlInstanceScheduleItem -StartDay Friday -StopDay Friday -StartTime "11:00" -StopTime "17:00"
$newSchedule.add($newScheduleFriday)

New-AzSqlInstanceStartStopSchedule -InstanceName $SqlMIName -ResourceGroupName $RgName -TimeZone "Central Europe Standard Time" -ScheduleList $newSchedule

Check a schedule

To check an existing schedule, use Get-AzSqlInstanceStartStopSchedule, such as the following sample script:

$currentSchedule = Get-AzSqlInstanceStartStopSchedule -InstanceName $SqlMIName -ResourceGroupName $RgName
$scheduleItemsList = $currentSchedule.ScheduleList
$scheduleItemsList

Update schedule

To update an existing schedule to stop and start a SQL managed instance, use New-AzSqlInstanceStartStopSchedule and New-AzSqlInstanceScheduleItem, such as the following sample script:

$currentSchedule = Get-AzSqlInstanceStartStopSchedule -InstanceName $SqlMIName -ResourceGroupName $RgName
$scheduleItemsList = $currentSchedule.ScheduleList

# Remove Thursday item
$scheduleItemsList = $scheduleItemsList | Where-Object { $_.StartDay -ne "Thursday" }

# Adjust Friday item
$fridaySchedule = $scheduleItemsList | Where-Object { $_.StartDay -eq "Friday" }
$fridaySchedule.StartTime = "09:00"

# Add new Thursday item
$newScheduleThursday = New-AzSqlInstanceScheduleItem -StartDay Thursday -StopDay Thursday -StartTime "12:00" -StopTime "18:00"
$scheduleItemsList += $newScheduleThursday

# Update schedule with new configuration
New-AzSqlInstanceStartStopSchedule -InstanceName $SqlMIName -ResourceGroupName $RgName -TimeZone "Central Europe Standard Time" -ScheduleList $scheduleItemsList

Delete a schedule

To delete an existing schedule, use Remove-AzSqlInstanceStartStopSchedule, such as the following sample script:

Remove-AzSqlInstanceStartStopSchedule -InstanceName $SqlMIName -ResourceGroupName $RgName

Create schedule

To create a schedule to stop and start a SQL managed instance with the Azure CLI, use az sql mi start-stop-schedule create, such as the following sample script:

scheduleItems="[{'startDay':'Monday','startTime':'10:00','stopDay':'Monday','stopTime':'18:00'},{'startDay':'Tuesday','startTime':'10:00','stopDay':'Tuesday','stopTime':'18:00'},{'startDay':'Wednesday','startTime':'12:00','stopDay':'Wednesday','stopTime':'22:00'},{'startDay':'Thursday','startTime':'14:00','stopDay':'Thursday','stopTime':'20:00'},{'startDay':'Friday','startTime':'14:00','stopDay':'Friday','stopTime':'20:00'}]"

timezone="Central Europe Standard Time"

az sql mi start-stop-schedule create --mi "$instanceName" -g "$resourceGroupName" --timezone-id "$timezone" --schedule-list "$scheduleItems"

Check a schedule

To check an existing schedule, use az sql mi start-stop-schedule show, such as the following sample script:

az sql mi start-stop-schedule show --mi "$instanceName" -g "$resourceGroupName"

Update schedule

To update an existing schedule to stop and start a SQL managed instance, use az sql mi start-stop-schedule update, such as the following sample script:

# append an item
newScheduleItem="{'startDay':'Friday','startTime':'09:00 PM','stopDay':'Friday','stopTime':'11:00 PM'}"
az sql mi start-stop-schedule update --mi $instanceName -g $resourceGroupName --add schedule_list "$newScheduleItem"

# remove an item
#items in list are indexed (0 based)
az sql mi start-stop-schedule update --mi $instanceName -g $resourceGroupName --remove schedule_list 2

Delete a schedule

To delete an existing schedule, use az sql mi start-stop-schedule delete, such as the following sample script:

az sql mi start-stop-schedule delete --mi "$instanceName" -g "$resourceGroupName"

Create or update schedule

To create or update a schedule to stop and start a SQL managed instance call the Start Stop Managed Instance Schedules - Create Or Update API and adjust the body content to match your schedule:

PUT https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/startStopSchedules/default?api-version=2022-08-01-preview

{
  "properties": {
    "timeZoneId": "Central European Standard Time",
    "description": "This is a schedule for our Dev/Test environment.",
    "scheduleList": [
      {
        "startDay": "Monday",
        "startTime": "07:30",
        "stopDay": "Wednesday",
        "stopTime": "17:00"
      },
      {
        "startDay": "Thursday",
        "startTime": "15:00",
        "stopDay": "Friday",
        "stopTime": "15:00"
      }
    ]
  }
}

Check a schedule

To check an existing schedule, call the Start Stop Managed Instance Schedules - Get API:

GET
https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/
providers/Microsoft.Sql/managedInstances/{managedInstanceName}/startStopSchedules/default?api-version=2022-08-01-preview

Delete a schedule

To delete an existing schedule, call the Start Stop Managed Instance Schedules - Delete API:

DELETE
https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/
providers/Microsoft.Sql/managedInstances/{managedInstanceName}/startStopSchedules/default?api-version=2022-08-01-preview