Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
andy-18
Starting Member
1 Post |
 Posted - 2010-05-03 : 03:31:32
|
| Hi,I am quite new to this. I have read about the Database Mirroring concept and I understand that there's Principal and Mirror involved. My question is - if the Principal is down due to hardware issue (assuming we are going for High Protection mode) by redirecting the client to the Mirror server. So right now all the requests are being processed by the Mirror server, what if when the Principal has recovered to services, is there data will be sync automatically between the Principal and Mirror and only after we update the connection string to point back to the Principal?In MySQL, I understand we can setup the Master-Master replication which can have the data sync between nicely but I am not sure how this work for SQL 2008. |
|
|
vmenon
Starting Member
17 Posts |
Posted - 2010-05-14 : 02:37:13
|
| Please refer to article(s)http://msdn.microsoft.com/en-us/library/ms189977.aspxhttp://msdn.microsoft.com/en-us/library/ms191449.aspxThere is a diagramatic explanation on what will happen in case the principal is lost / time for some duration. |
 |
|
|
|
|
|
Advise Needed for Database Mirroring