How to setup Geo-Replication in Azure SQL databases ?

In this video, we configure the SQL High Availability and Disaster Recovery in Azure SQL Database. There are two features available in Azure SQL Database:-
1. Active Geo-Replication
2. Failvor Group
Azure SQL DBA Videos: • Free Azure SQL DBA Tra...
#Azure #AzureSQL #SQLAzure #DBA

[@Niravgandhi]

Azure SQL DBA Videos: ruclips.net/p/PL9aNQqB-xjbCUkpXNzGV1A8v7JGUgCpZY

[@quocdunginfo]

Your demonstration is fantastic, it help me experience on How to replicate Azure SQL Db across regions

[@Niravgandhi]

Thanks

[@mainoddinkhazi5148]

Bhai Great Job!!!. I have gone through with all your video really fantastic learning...Keep doing it up and it was really helpful for the new learner like me.

[@Niravgandhi]

Thank you.

[@ajitedake925]

Great explanation

[@Niravgandhi]

Glad it was helpful!

[@robertoschatz5109]

Excellent! Thank you very much for sharing.

[@srinivasmerugu8029]

Excellent! It will more usefull in my project. Thank you very much

[@Niravgandhi]

Glad it was helpful! Please share the video in your connection and LinkedIn

[@Faisal.Software]

Thanks for sharing, really helped a lot, and wishing you all the best ~~~

[@MeetaliSharma-np5ug]

Thanks for the amazing explanation. Could you please confirm whether we can connect to secondary DB from SSMS even when primary DB is online and secondary DB is read only or we need to force failover to be able to connect to secondary DB from SSMS?

[@Niravgandhi]

Yes, we can connect the database

[@vigneashselvaraj3592]

Excellent video!

[@Niravgandhi]

Thank you very much!

[@manisanthosh126]

Such a great explanation

[@Niravgandhi]

Thank you

[@SandeepSingh-hn6it]

Great explation, which IDE are using here to Connect the db? while creating it automatially 2db first server and then one another not sure why can you guid me ! thanks

[@Niravgandhi]

Not clear, can u please type your question again

[@SandeepSingh-hn6it]

@@Niravgandhi 1. which IDE SQL editory are using to Connect the db? 2. it alway requird to Create Server under Server is LIke Cluster model ?

[@Niravgandhi]

SSMS

[@MyksLife]

Great tutorial 💪 Thank you for sharing.

[@Niravgandhi]

Thank you very much.

[@kishoreevani5813]

Thank you for sharing this great video. I have a small doubt, as geo-replication db level allows only asynchronous replication so force failover we have done, does it mean do we have data loss? please clarify.

[@Niravgandhi]

You can't loss the data. If it is plan force failover

[@dancemusicstudio2835]

what is the use of replicated database. we need to set up web services app to talk this database and deploy apps which talk to these app specific to those regions right

[@LeventeGaborDrNyars]

Unfortunately, in the Azure Data Studio, I deleted localhost, default from Servers. How can I serstore this Localhost to be able to import AdventureWorks2019?

[@Niravgandhi]

Clock on new connection and start again

[@TheMrvy]

Amazing!!

[@Niravgandhi]

Thanks!!