May 23, 2008 at 10:27 am
Hi,
Our company has a plan to implement Sql Server Mirroring for Disaster Recovery process. I have read sql server articles and forums about the issue. I still have several questions about the sql server mirroring:
1. Let's say we have power outage, the failover happened. Server A is the principal and B is the mirror server. The mirror server (B) now becomes principal server. Once the power restored, we would like to resume the role of server A as the principal and server B becomes the mirror server again. How this can be done? What happen to the new transactions in server B? Will the entire system recoginze that server A is back on line and the switch back is automatically done, including the synchronization between the mirror and principal server?
2. If we would like to have a witness server beside the principal and mirror server, how many SQL Server license should be buy? I know for sure we must have 2 SQL Server license for both principal and mirror? How about the witness server?
Thanks in advance
Sol Santoso
May 23, 2008 at 12:13 pm
1. When Server_A comes back online it will take the Mirror role and resynchronize with Server_B, the principal. To switch the roles again would be done manually.
2. One license will cover both the mirror and principal as long as the mirror is used for nothing else. If it's used for snapshots, for reporting, then you need another license. And for the Witness, that can run on SQL Express so no license for that.
If in doubt, ask your Microsoft Technical Account Manager.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply