Managed Instance disaster recovery

Question

Managed Instance disaster recovery

Lou

SSCrazy

Points: 2929
More actions
December 27, 2021 at 11:56 pm
Go to Answer
#3967629

Hi All,
I have the tasks to evaluate disaster recovery for a General Purpose managed instance, which option is the favorite between you dear group.
Best Regards
Johan Bijnens

SSC Guru

Points: 135368
More actions
December 28, 2021 at 7:47 pm
Answer
#3967945

the options are documented: Overview of business continuity with Azure SQL Database & Azure SQL Managed Instance
and Restore a database in Azure SQL Managed Instance to a previous point in time

Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004312 More actions · Answer 1

Heh... <sarcasm = on> It's a "managed instance"... there shouldn't be any disasters, right? <sarcasm = off>

Considering the differences of the cloud providers and the different plans they all have, I'd have to say that there's probably no such thing as "General Purpose managed instance" DR plan, and I'm not being sarcastic there in on bit.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)