Database Mirroring in SQL Server || Database Mirroring Configuration || Ms SQL

Database mirroring is a solution for increasing the availability of a SQL Server database.
SQL Server database mirroring is a disaster recovery and high availability technique that involves two SQL Server instances on the same or different machines. One SQL Server instance acts as a primary instance called the principal, while the other is a mirrored instance called the mirror. In special cases, there can be a third SQL Server instance that acts as a witness.
Log shipping Configuration: • Log Shipping in SQL se...
Endpoints in SQL server: • Endpoints in SQL serve...
#DatabaseMirroring

[@srinaths6381]

U r dominated techbrothers 🤗

[@kallurisaikumar1546]

I’m not interested to watch tech brothers video

[@rahulshende2526]

Hi Sir, Thank's a lot for this video. My all doubts are cleared after watching this configuration of mirroring. Thank you once again.

[@banalasiva5743]

Super video i understand clearly

[@suryakant2418]

Hi.. Thanks for wonderful video.

[@user-wf8ow9sf9h]

Hi Thank you very much for the very informative video.

[@HiranthaIddamalgoda]

Nice. Well explained. Thank you

[@mrgogate]

Super Boss !!

[@ravulakishan5998]

thank you bro so much

[@pramod1234ist]

Thanks a lot sir.....

[@abe92139]

Thanks!

[@sontosh007]

Thank you

[@Motivandovidasz]

Muito obrigadoo !

[@advishwakumaraamarasinghe1486]

Thanks

[@shreharshethaauto8428]

hi sir while configuring to mirroring in mirror server we are getting listeners port getting 5023 where as principal instance listeners port is 5022

[@geeksified]

can you setup db mirroring on servers on 2 different AWS Lightsail accounts? We're trying to be online as much as possible as one of our script is messing up the server, and it hangs the server up that it becomes unresponsive. Until we found where this script is or what issue it does create, we need to be able to serve our app as much as we can. I haven't done with the video yet, but your sample is basically within a single domain.

[@SudarshanReddy897]

great video..have one doubt that if we want to failover multiple databases just say like 20db's, how can we do at a time?

[@SunindraSeepana]

Failoer concept is excellent sir God bless you

[@righttolearnbk]

Thank you.

[@SunindraSeepana]

Sir could you please upload Clustering cocepts

[@righttolearnbk]

@@SunindraSeepana At present I don't have the setup ready in my pc, we need good hardware configuration, planning to do it with Azure Virtual Machines..

[@sqlserver6395]

can we configure logshipping in clustering if possible how? can please explain me

[@ajbxhrfgirc-fy9lg]

Excluding the endpoint videos . What is the setup u did with vms before begining the main topic .please tell 😢

[@kshanker72]

how to fix if someone has changed recovery model to simple for mirrored database

[@suryakant2418]

I am trying to create mirror with two machines but getting error 923

[@sivasankar7013]

But for 2008 it asks database option in mirror server to restore

[@HARISHREDDY-kn5qe]

why didn't we configure mirror DB in standby mode?

[@charlykjoseph]

Which edition of 2014?

[@toprerishi]

Is Mirror possible for SQL Express?

[@JSunilKumar0508]

How to troubleshoot 927 error in Database Mirroring?

[@a2zguide216]

Can I configure Database Mirroring on the same computer with a different SQL Server Instances

[@righttolearnbk]

Yes

[@3bdulla3ngineer]

Hi Thank you very much for the very informative video. I have a question regarding mirroring operating modes and MS SQL editions. High Performance (asynchronous) mode is supported only on MS SQL Enterprise edition, right? I cannot run it on MS SQL Standard edition, right?

[@Venkat6728]

Ms SQL server standard support database mirroring.

[@shaficicabdi9553]

hello I have a problem in SQL Server 2014 Mirroring " the server network address cannot be reached mirroring 1418" and I am using IP address both Computers Principle and Mirror Servers. so, how to fix it?

[@righttolearnbk]

Could be a endpoint issue. Watch this kzbin.info/www/bejne/eHeThGuLfK-Ha9E

[@rahulshende2526]

Make sure you have restore FULL & T_LOG Backup with No Recovery Option.

[@venkateshthummuru9245]

how did you configure 5022 as port for both principal and mirror servers

[@delta3black563]

Because database are in different machine.

[@rahulshende2526]

We can configure mirroring with 5022 Port if we are using different Server / Machin. If we configure mirroring on same / only one Machin then port will be 5022(Principal) & 5023(mirror).

[@SudeerRao]

Can you set up database mirroring on virtual machines hosted on AWS with SQL Server installed. Also without domain controller.?

[@righttolearnbk]

Yes we can. We can even setup between different domains

[@proteinfoodtravel]

@@righttolearnbk can you make a video on this sir.

[@racemchoura5441]

please the script of mirroring

[@dragonballsupere6316]

Sir,What about service account id should be same or not

[@righttolearnbk]

Service account need not to be same. I have tested this in production environment and it is working well.

[@dragonballsupere6316]

@@righttolearnbk Thanks Sir, but can we configure 1 with window authentication and 1 with sa

[@anandprakashtiwari1457]

Is it clustered setup

[@righttolearnbk]

No