How to Setup Mirroring in SQL Server 2016 - SQL Server 2016 DBA Tutorial

How to create or setup Mirroring in SQL Server 2016?

What is Database Mirroring :
As per Microsoft "Database mirroring is a solution for increasing the availability of a SQL Server database. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model."

We will cover follow items in this video
1) What is setup for Mirroring
2) What is Principle, Witness and Mirror Server
3) Prepare your Database by using full backup and Tran log backup before enabling Mirroring.

How to setup Database Mirroring in SQL Server 2016
How to create Database Mirroring in SQL Server 2016
What is Database Mirroring in SQL Server
Step by step Database Mirroring SQL Server Demo

Link to scripts used in SQL Server / TSQL Tutorial Video

Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server 2016 DBA Tutorial
SQL Server / TSQL Tutorial ( Beginner to Advance)

[sandrawatt]

Your video was helpful, but more importantly well organized and concise. No wasted time on a lot of rambling and repetition. Thank you!

[Dafugcasimock]

Clear, short, Straight to the point, thanks, very good video

[MrBrijendrakumar]

Dear Sir, when we configure sql server 2016 for mirroring we find the error:
database cannot be opened. it is in the middle of a restore error no 927

[ferozsayyed]

Thank you so much sir for sharing this mirroring video nice explained no Waste of time

[mvparrales]

Really good video, very clear and helpful. Thanks a lot.

[vijaynarasimha]

Very much helpful. Thank you.
Please keep them coming.

[LnelyRogue]

Hello
Despite usage of Witness Server, you did Manual Failover. Please explain if Automatic Failover wouldn't happen with your setup?
Second, i was expecting that you would make Principal DB unavailable (drop, offline etc) and Auto Failover would happen. Would this happen?
-- In 'thoughts'...

[ClevergunsYT]

can i use this on two different server with different ip address?

[ahmedzidan]

dear
I would like to ask..when i start mirroring it gives an error says database can;t be opened..it's in middle of restore...any ideas?

[FrancescoDiblasio]

Thank you! really a clear explaination!! Regards!

[quantumsoftware]

hi. Assume that witness and principle instance reside at server 1. And mirror instance at server 2. When Server 1 failed, an application sql connection string is point to witness instance. Will the application able to access the mirror database at server 2?

[atul]

do we really need to have the shared drive between principal and mirror server for backup and restore database.

or can we configure mirroring without having shared drive like just by transferring db backups from principal to mirror server and restore it on mirror.

Is shared drive mandatory between these 2 servers for db backup and restore ?

[radatann]

Hi, I have some question to ask about instance database in sql server 2016.
I want to do standby server but i am not sure which technology that i should do between Mirror and Replication.
Do you have any suggestion for this point ?

[mukulbiswas]

On principal server it showing port number 5022 and mirror server its showing 5033. Ho to fix the issue??

[nexusroc]

Hi Bro,
Thank you for your sharing. But I restored my DB with No recovery. When I set up Mirroring. It showed 'Error 927. It's in the middle of a restore'.
Why? Thanks!

[nexusroc]

Hi Bro,
I have another question about mirroring. DO you know why Microsoft will not support mirroring in the next version? After this, we just use Transaction Log Shipping to keep high availability?

[adithyasomayagi]

I get 927 error, it says middle of restore. I m using 2016 Ssms

[ferrad]

Hi TechBROTHERSIT
I would like to know how to create a new instance on SQL SERVER please

Thank you

[vikashgupta]

Dear sir when i configure sql server 2016 for mirroring we find the error:
database cannot be opened. it is in the middle of a restore error no 927. Kindly help me.

[arcastillof]

I cannot start mirroring, I have error 927 the database is being restored