InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 02:03:47 GMT20http://www.sqlservercentral.com/Forums/Topic1406256-1549-1.aspxThanks all for you answers.Have a nice day!Tue, 15 Jan 2013 09:12:32 GMTcygne17_2 77208http://www.sqlservercentral.com/Forums/Topic1406256-1549-1.aspxAs Joie has stated and as Paul Randal's article explains even with safety on (synchronous mode), without a witness a mirror disconnection will allow the principal to stay online and the send queue to grow, this represents the data loss risk factor.Also, in normal operation, if the principal fails before this send queue has been processed by the mirror, the mirror needs to be forced into service at the risk of data loss.Tue, 15 Jan 2013 04:20:36 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1406256-1549-1.aspx[quote]But I still not understand why ?In safety-mode, principal do not applied change on datafile until it's write in transaction log of the mirror.So, if principal crashed, the transaction not written to the mirror will be rollback on the old principal when it will come back.So the data will not be lost because they will not be applied on old principal.missing something ?regards,[/quote]There are a couple of reasons why transactions would not have come over I can think of. One is if the mirror server was in a suspended state when the primary failed and then forced to become the primary. In that scenario there are commands that could have applied on the primary that did not apply on the mirror.Another reason could be because db mirroring works in near real-time using queues. Depending on the amount of traffic and the latency between the primary and mirror servers I can see a scenario where commands are not yet received at the mirror before failover. I believe Paul Randal did an article on this for TechNet magazine.[i]Some time later...[/i]Yep, he did.[url=http://technet.microsoft.com/en-us/magazine/hh334997.aspx]http://technet.microsoft.com/en-us/magazine/hh334997.aspx[/url]Mon, 14 Jan 2013 13:22:13 GMTJoie Andrewhttp://www.sqlservercentral.com/Forums/Topic1406256-1549-1.aspxBut I still not understand why ?In safety-mode, principal do not applied change on datafile until it's write in transaction log of the mirror.So, if principal crashed, the transaction not written to the mirror will be rollback on the old principal when it will come back.So the data will not be lost because they will not be applied on old principal.missing something ?regards,Mon, 14 Jan 2013 11:42:44 GMTcygne17_2 77208http://www.sqlservercentral.com/Forums/Topic1406256-1549-1.aspx[quote][b]cygne17_2 77208 (1/14/2013)[/b][hr]Hi,yes I read this article.I understand the possible data loss with high-performance mode(asynchronous).But I still don't understand why we can have possible data loss with high-safety mode?In high-safety mode, transaction committed on the principal are also committed on the mirror.Do you have an idea ?best regardsDavid[/quote]It said it in the article:If service is forced because the principal server has failed, potential data loss is depends on whether any transaction logs were not sent to the mirror server before the failure. Under high-safety mode, this is possible only until the mirror database becomes synchronized.There is a possibility if the principal and mirror are synchronized, that when the principal fails that it may not have sent the most recent transactions to the mirror database. These would be transactions that had been queued but not yet sent, perhaps due to network latency or a high volume of transactions. At this point, the databases may have actually been in a synchronizing state but SSMS or Mirroring Monitor had not yet changed to reflect it.Mon, 14 Jan 2013 07:08:31 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1406256-1549-1.aspxThanks for your answer.It's clear now.best regardsMon, 14 Jan 2013 07:01:38 GMTcygne17_2 77208http://www.sqlservercentral.com/Forums/Topic1406256-1549-1.aspx[quote]"When the partners are connected and the database is already synchronized, manual failover is supported. If the mirror server instance goes down, the principal server instance is unaffected and runs exposed (that is without mirroring the data). If the principal server is lost, the mirror is suspended, but service can be forced to the mirror server (with possible data loss). "[/quote]The possible data loss is when the priciple fails while the mirror was also failed. In that scenario if the mirror is brought up and forced to be the new principle data loss may have occurred because transactions may have been on the principle that were not applied to the mirror yet.Mon, 14 Jan 2013 06:51:39 GMTJoie Andrewhttp://www.sqlservercentral.com/Forums/Topic1406256-1549-1.aspxHi,yes I read this article.I understand the possible data loss with high-performance mode(asynchronous).But I still don't understand why we can have possible data loss with high-safety mode?In high-safety mode, transaction committed on the principal are also committed on the mirror.Do you have an idea ?best regardsDavidMon, 14 Jan 2013 06:44:48 GMTcygne17_2 77208http://www.sqlservercentral.com/Forums/Topic1406256-1549-1.aspxDid you follow the link in that msdn article you referenced, [url]http://msdn.microsoft.com/en-us/library/ms189977(v=sql.105).aspx[/url]? It does a good job of explaining what happens.Sat, 12 Jan 2013 01:42:30 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1406256-1549-1.aspxHi,In database mirroring, for "high-safety mode without automatic failover" it is mention that :"Every transaction committed on the principal database is also committed on the mirror server, guaranteeing protection of the data. This is achieved by waiting to commit a transaction on the principal database, until the principal server receives a message from the mirror server stating that it has hardened the transaction's log to disk."And it is also mention that:"When the partners are connected and the database is already synchronized, manual failover is supported. If the mirror server instance goes down, the principal server instance is unaffected and runs exposed (that is without mirroring the data). If the principal server is lost, the mirror is suspended, but service can be forced to the mirror server (with possible data loss). "So, If the principal server is lost, why service can be forced to the mirror server WITH POSSIBLE DATA LOSS ?Why with WITH POSSIBLE DATA LOSS ?ref: http://msdn.microsoft.com/en-us/library/ms179344(d=printer,v=sql.105).aspxregards,cygneFri, 11 Jan 2013 14:07:06 GMTcygne17_2 77208