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

4
Leave a Reply

avatar
4 Comment threads
0 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
3 Comment authors
Tesfaye HiwotMake Money Fasttohagglemaillot de foot Recent comment authors
  Subscribe  
newest oldest most voted
Notify of
trackback
maillot de foot

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
Make Money Fast

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

Tesfaye Hiwot
Guest
Tesfaye Hiwot

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.