How to Restore Deleted Azure SQL Database | Using PowerShell Commands | Restore Deleted DB

How to Restore Deleted Azure SQL Database | Using PowerShell Commands | Restore Deleted DB

---------------Get a DB in a Server-----------

Get-AzSqlDatabase -ResourceGroupName "cloudknowledge" -ServerName "cksqldbserver" -DatabaseName "testdbforrestoration"

--------------Details about the Deleted Database:-------------

Get-AzSqlDeletedDatabaseBackup -ResourceGroupName "cloudknowledge" -ServerName "cksqldbserver" -DatabaseName "testdbforrestoration"

----------------Store it in a variable------------

$DeletedDatabase = Get-AzSqlDeletedDatabaseBackup -ResourceGroupName "cloudknowledge" -ServerName "cksqldbserver" -DatabaseName "testdbforrestoration"

-----------------Restore Command-----------------

Restore-AzSqlDatabase -FromDeletedDatabaseBackup -DeletionDate $DeletedDatabase.DeletionDate -ResourceGroupName $DeletedDatabase.ResourceGroupName -ServerName $DeletedDatabase.ServerName -TargetDatabaseName "RestoredDatabase" -ResourceId $DeletedDatabase.ResourceID -Edition "GeneralPurpose"

#restore #restoredeleteddb #azuresql #azuresqldb #powershell #powershell

[ramanaswamy]

Can you pls create a playlist for databricks too 🙏🏻

[deepalimokal]

Can we do this with help of Azure powershell line script?