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 |
|
methodology
Starting Member
31 Posts |
 Posted - 2007-03-30 : 04:35:53
|
| HiI need to know exactly the sequence of events in synchronous mirroring mode. What im reading is this:1. tranaction recved from a client by primary2. primary writes trans to trans log3. log written to dbase ie to disk from log on primary and concurrently sends log to mirror.4. Primary waits for response from mirror5. Mirror writes log to disk6. mirror returns acknowledgement to primary.7. primary sends conf to client.I need to know what happens if the mirror DOES NOT SEND THE ACK. Q1. Does the primary roll the dabse back?Q2. if so, the data goes back into the trans log awaiting response from mirror and subsequent commitall on primary, correct?Q2. Whats the timeout period for an ack from the mirror?Question 1 is the most important. ive bought bloody standard verion with its sync mirroring as oppoed to the laughably expensive Ent edition with its ASYN nmirroring and im wondering if I can get away with it....ThanksAlastairMethodology |
|
|
SatyaSKJ
Starting Member
46 Posts |
|
|
bpgupta
Yak Posting Veteran
75 Posts |
Posted - 2007-04-17 : 09:19:46
|
| Every this depend upon the type of mirroring you have choose.The question ans's depend upon that only. |
 |
|
|
|
|
|
2005 SYNC MIRRORING - EXACT sequence of events..