July 21, 2025 at 5:19 am
I am creating a Disaster Recovery plan for Below Data pipeline.
I need to plan for Azure SQL Data recovery and Partial Data recovery.
May someone please help me with list what all I must consider while doing DR Plan for Azure SQL Data recovery and Partial Data recovery.
Thanks a lot.
July 22, 2025 at 6:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
July 22, 2025 at 10:13 am
Have you read the documentation Microsoft provide for Azure SQL DB redundancy, that would be a good starting place
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 22, 2025 at 4:35 pm
Strong recommendation. Read through the Azure documentation on backups, restores, and retention. Partial recovery is likely to be a challenge (it's a challenge on a local machine). You're going to need a mechanism (I'd recommend scripting it out and testing it several times) to restore a database backup to a new database (only way it works in Azure) and then figure out how to migrate data from that location. None of this is easy. Also, remember, Azure has a DR plan and multiple DR scenarios mapped out. Perry has pointed out part of it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 24, 2025 at 8:31 am
What do you do when business wants an on-premises "backup" just in case the cloud would vanish or become unavailable. (We would have other problems, but let start with this)
Creating bacpacs?
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply