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 , , , , , , , , , | 5 Comments
Subscribe
Notify of
guest
5 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
trackback
maillot de foot
10 years ago

maillot de foot…

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

tohaggle
10 years ago

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

Make Money Fast
Make Money Fast
10 years ago

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

Tesfaye Hiwot
Tesfaye Hiwot
8 years ago

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.

tedirivan
tedirivan
3 years ago

can it to use in different machine server?, how to configure?