Configuring Database mirroring step by step – SQL Server 2012

Configuring database mirroring step by step in SQL Server 2012

Database Mirror topology_Diagram

Here is a video that demonstrates how to configure database mirroring on SQL Server 2012.

Step by Step guide to database mirroring – Part 1

Step by Step guide to database mirroring – Part 2

Here is the article to configuring database mirroring using SQL Server 2012 with screenshots.

http://www.mssqlfix.com/2011/11/step-by-step-guide-to-configure.html

Also learn:

Monitor Database Mirroring using SSMS

Monitor Database Mirroring using T-SQL

Monitoring Database mirroring using Email Alerts

Monitoring Database mirroring using custom metrics

A complete look – SQL Server Database mirroring

Posted in High Availability, SQL Server DBA | Tagged , , , , , , , , , | 4 Comments

Leave a Reply

4 Comments on "Configuring Database mirroring step by step – SQL Server 2012"

Notify of
avatar
Sort by:   newest | oldest | most voted
trackback

maillot de foot…

The weblog You have write is extremely nicely written and quite insightful thanks for good posta?|…

tohaggle
Guest

Hello mate, very nice and informative article you have shared with all of us. I appreciate your efforts. Thanks

Make Money Fast
Guest

Pretty! This has been a really wonderful article. Many thanks for supplying this info.

Tesfaye Hiwot
Guest

Nice tutorial! You should have thrown in a little example about what happens when you lose the witness after a failover (you lose access to the DB). Folks running Windows 2012 in a VMware environment can run into this situation if they are affected by the restart bug after automatic updates have been applied in a VMWARE ESX 5.5+ environment. Loss of connectivity caused the failover (ok, that’s fine), but then the witness rebooted automatically and never left the Windows start screen, so no DB access until the witness was back up.

wpDiscuz