• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 444
  • Last Modified:

SQL Server Database mirroring

I have a question about Database Mirroring.  If you have a principle server and a mirror server talking to each other and the mirror breaks, at what point does the mirror server become the principle server?  In addition, when the mirror breaks between the two servers, can the mirror or secondary server assume the principle role right away or do you have to perform a restore in order to get the principle server to operate as the primary server altogether?
0
VBBRett
Asked:
VBBRett
  • 2
  • 2
3 Solutions
 
VBBRettAuthor Commented:
Anybody care to comment?
0
 
Jagdish DevakuSr DB ArchitectCommented:
Hi,

With Database Mirroring:

Data Transfer:    Individual T-Log records are transferred using TCP endpoints
Transactional Consistency:  Only committed transactions are transferred
Server Limitation:   Can be applied to only one mirror server
Failover:   Automatic (Only if witness server is configured)
Failover Duration:  Failover is fast, sometimes < 3 seconds but not more than 10 seconds
Role Change:   Role change is fully automatic
Client Re-direction:  Fully automatic (if the alternate server connection string is used.)

Jagdish
0
 
Steve BinkCommented:
The mirror will only become a principal server if:

a) the mirror is configured with a witness under high availability rules
b) you manually switch the mirror

After a switch has been made, you need to manually push it back.  This usually means restoring the mirror first.
0
 
VBBRettAuthor Commented:
So if the mirror were to break, what happens to the principal role and the mirrored role?  Do they switch?
0
 
Steve BinkCommented:
That depends on if you have automatic failover with a witness, and which server becomes unavailable.  I highly recommend you review these pages:

Database Mirroring Overview
Synchronous Database Mirroring
Database Mirroring Witness
Automatic Failover

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now