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.


#DatabaseMirroring

[rahulshende]

Hi Sir,

Thank's a lot for this video.

My all doubts are cleared after watching this configuration of mirroring.

Thank you once again.

[wfowsfh]

Hi

Thank you very much for the very informative video.

[shreharshethaauto]

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

[SudarshanReddy]

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?

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

[sqlserver]

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

[ajbxhrfgirc-fylg]

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

[kshanker]

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

[SunindraSeepana]

Failoer concept is excellent sir God bless you

[HARISHREDDY-knqe]

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

[suryakant]

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

[sivasankar]

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

[bdullangineer]

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?

[azguide]

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

[shaficicabdi]

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?

[SudeerRao]

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

[venkateshthummuru]

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

[JSunilKumar]

How to troubleshoot 927 error in Database Mirroring?

[dragonballsupere]

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

[Venkat]

Ms SQL server standard support database mirroring.