How to recover/restore Azure SQL Database from the backpack file which is currently in leased mode .
Kaushal Kishor Rathore
Technical Lead @ Tech Mahindra | Azure Data Engineer | 3X Azure Certification I Azure Data Bricks, SQL Database ,Azure Synapse, Azure Data Factory, Snowflake, Veem,pySpark,MSBI,T-SQL,C#
Issue Definition:
pass db server deleted kkxyzcorp.database.windows.net and want to recover it.
?
Action Plan:
?
Note: Please note that the retention period is of 7 days and it’s not possible to restore the server if it exceeds 7 days.
nbsp;If that is the scenario we suggest you import the database from bacpac file using SQL Package or SSMS.
?
?
1.???? First break the lease from the storage account and download the backpack file.
2.???? Create SQL Database Server
3.???? Import database using SSMS or you can use Import database using SQL Package(Using SQLPackage to import or export SQL Server and Azure SQL DB - Microsoft Community Hub)
4.???? Right click on?Databases?and select?Import Data-tier Application
?
4.1 Click on the Next button.
?
4.2? Choose the .bacpac file that was created above and click?Next.
?
4.3? As of your business requirement you can choose the service tier(Edition of Microsoft Azure SQL Database) and database name, Click on Next button. After checking the settings.
?
4.4? After Verified all the checklist, Click on Finish?button.
For security point of view do not use public access instead use selected network access. Add a virtual network rule /firewall rules.
Senior Software Engineer at Morningstar
10 个月Very helpful!
Advanced Cloud Engineer(ACE) at Microsoft
10 个月Very informative
Azure DevOps | Azure Infrastructure | Azure Kubernetes | Docker | Terraform
10 个月I was looking for article like this, It's really helpful
Sr Data Analyst @Beyondsoft | Ex-TechM
10 个月Very informative
Data Engineer @ Capgemini | Azure Databricks, Python ,ETL/DWH ,SQL Developer
10 个月Good information