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: kzbin.info/aero/PL9aNQqB-xjbCUkpXNzGV1A8v7JGUgCpZY

[@robertoschatz5109]

Excellent! Thank you very much for sharing.

[@quocdunginfo]

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

[@Niravgandhi]

Thanks

[@Faisal.Software]

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

[@vigneashselvaraj3592]

Excellent video!

[@Niravgandhi]

Thank you very much!

[@MyksLife]

Great tutorial 💪 Thank you for sharing.

[@Niravgandhi]

Thank you very much.

[@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.

[@manisanthosh126]

Such a great explanation

[@Niravgandhi]

Thank you

[@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

[@TheMrvy]

Amazing!!

[@Niravgandhi]

Thanks!!

[@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

[@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

[@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

[@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