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 |
|
jfnance32
Starting Member
1 Post |
 Posted - 2011-08-22 : 17:13:54
|
| We have many SQL server centric systems including systems that use BizTalk and SharePoint.I have three questions that are on possible data loss under a heavy load during a failover situation.In the white paper, “Failure Is Not An Option: Zero Data Loss and High Availability” it states, “Depending on how important zero data loss is compared to availability, if you really want zero data loss, the system must be taken offline as soon as the mirror is not available. In most cases, availability is more important. However, in the scenario this paper discusses, zero data loss is higher priority than high availability. Therefore, if either the principal or the mirror fails, the application is taken offline, and one of the log shipping secondaries is converted to the new synchronous mirror. Finally, the application is brought back online.”When it talks about data loss, is it referring to loss of data transactions that have reported back to the application as committed transactions?Is there a higher change of data loss in a simple active-passive cluster vs. a data mirror environment?Under a heavy load, committed transactions can get lost during the switchover from active to passive node in a simple active-passive cluster?James Nance |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2011-09-09 : 14:49:35
|
| there is no data loss for clustersmirroring is not msdtc aware, meaning you need to consider and explore other alternatives if want mirroring as your HA solution.http://support.microsoft.com/kb/926150--------------------keeping it simple... |
 |
|
|
|
|
|
|
|
Failover - Data Loss