How to Find the SQL Database ID for a Point-in-Time Restore (PITR) in Azure

Avatar
Reggie Rudolph
  • Updated

 

Introduction

When performing a Point-in-Time Restore (PITR) of an Azure SQL Database, you may need the Database ID to correctly identify the source database. This article outlines the steps to find the SQL Database ID using the Azure Portal, Azure CLI, and Azure PowerShell.

Expected Outcome

After performing a Point-In-Time-Restore the user is able to find the SQL Database ID. The database ID is a required parameter in some automation or scripting scenarios involving PITR.

Prerequisites

  • Make sure the user or service principal performing the action has Reader or Contributor access to the resource group containing the database.

Procedure

Option 1: Azure Portal

  1. Go to the Azure Portal.

  2. Navigate to SQL databases.

  3. Click on the target SQL database.

  4. In the Overview blade, scroll down and click on JSON View (usually under "Essentials").

  5. Look for the id field — this is the full Database Resource ID.

    Example format:

    pgsql
    /subscriptions/<subscription-id>/resourceGroups/<resource-group>/providers/Microsoft.Sql/servers/<server-name>/databases/<database-name>

Option 2: Azure CLI

You can retrieve the database ID using the Azure CLI:

bash
az sql db show \ --name <database-name> \ --server <server-name> \ --resource-group <resource-group-name> \ --query "id" \ --output tsv

This will return the full resource ID string of the database.

Option 3: Azure PowerShell

Run the following command in Azure PowerShell:

powershell
Get-AzSqlDatabase ` -ResourceGroupName "<resource-group-name>" ` -ServerName "<server-name>" ` -DatabaseName "<database-name>" | Select-Object Id

This will display the ID property of the specified database.

Additional Information

  • https://learn.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups

Articles in this section

See more