SQL Server DBA Tutorial 110-How to Setup Database Mirroring in SQL Server

In this video you will learn how to setup Database mirroring step by step process. Process explains how to prepare database for Mirroring, how to configure Principle server, what is principle and Mirror server in SQL Server Mirroring, how to configure Mirror server, how to configure witness server, how to failover and how to get required permission for Mirroring configuration in SQL Server.

Blog post link for the video:

Visit our website to check out SQL Server DBA Tutorial Step by Step

[charlesBleu]

This lesson saved me from a full night of mirroring frustration... Many thanks.

[JamesEstes]

Outstanding Video. Thank you for the clear and concise instruction. Worked flawlessly - even on SQL Server 2008 R2.

[whatiknowallmix]

clear cut explanation excellent tq Tech Bro's

[amosmaxwelldeen]

this lesson have help me so so much thx

[lahorifm]

Many thanks for such a nice detailed explanation.

[susantakumarrath]

Excellent explanation Tech Brothers.
I had a confusion about the use of credentials during connecting to the Mirrored instance while configuring.
Why not include the Mirror Configuration using T-SQL, like you did for Log shipping?

[oliviersanzot]

I'd still recommend Database mirroring for pricing considerations. If I'm not wrong, you don't have to pay a licence for the mirror instance. For some organizations, this is a great argument...

[InglesallYou]

I'm facing disk space issue and because of that I need to resize the disk in my principal source server is it possible I split the target data in the target servrer in 2 different locations I mean in 2 drives units while my source server the data are concentrate in only one driver unit? Currently my Source serverr is in E drive and Target server is in E. I want to keep the source server in E and target mirror server to E and D

[Venkat]

the awesome lesson about database mirroring.

[pedroemanuel]

Hello, I have a lab which is 1 domain controler, shared storage and 2 node sql. Its necessary to mirror if the two node are on a failover cluster? Because they are getting the data from the same storage..

Thanks

[salmanm]

What permissions did you grant to the Sql server service account?

[kundanivlogs]

I have one question here.! If fail over happens mirror DB became principal DB right.! we may get orphan user right? because only user's will be replicated to mirror DB not logins right? please ans me.

[mohamedabdullahi]

Thank you for explanation.
I tried to follow the steps in the video, and it fails when i click start mirroring and it says "The server network address "TCP://servers:5022" can not be reached or does not exist. Check the network address name and that the ports for the local remote endpoints are operational."
The network of two severs are OK, when i telnet the two ports from each other they connected.
Please help

[salehuddinisa]

Would you please show how to create other 2 instances, the mirror server and witness server. And also would you please go a little bit slow, 'cause for you it's just abc but for a new learner it's tough to follow when move fast. When after back up you go to the folder delete them and do other stuff, we didn't understand, so would you please go a little bit slower and explain what are you doing. thanks

[MotionInMotion]

This is used in case a SQL goes down, the other one takes over? Thanks!

[bextla]

in sql you connect same server or different? one is SQLMirroe

[RajeevRanjan-pfjy]

I am facing the issue while configuring the Database Mirroring like can not be reached or does not exist. check the network address name and that the ports for the local and remote endpoints are operational.(Microsoft SQL Server, Error : 1418). please suggest me what i have to do..please its very urgent.

[shrenikshah]

What If we take full backup with compressed mode, will DB mirroring work?

[JulioCruzcoach]

I just tried this and i receive an error that the database cannot ne opened because it's in the middle of a restore! :( Why were you able to?

[lekkalabalakrishna]

I did same as you said and every thing fine. but files not moving