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 |
|
Wrangler
Starting Member
35 Posts |
 Posted - 2011-04-19 : 19:36:16
|
| Wondering if this is common. On SQL 2008 VMWare machine using Mirroring sometimes taking a Snapshot of the VM will cause the mirror to failover to the second server. We use a 30 second failover delay. Thanks, |
|
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-04-20 : 08:54:55
|
| Cause sync issueRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBAMy Blogwww.aureus-salah.com |
 |
|
|
Wrangler
Starting Member
35 Posts |
Posted - 2011-04-20 : 11:44:23
|
| Jahanzaib, I don't really understand your response |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-04-20 : 11:53:09
|
| I'm not familiar with VMWare but if the snapshot process has to freeze the VM state, it could take long enough to trip the timeout threshold and fail over. Are you using a mirror witness? |
|
|
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-04-20 : 12:06:14
|
| that could be sync issue with primary and secondary node because when you take a snapshot of primary server then it freeze then move to secondary server yes offcourse witness server should be there because its automatically move on secondary serverRegards,Syed Jahanzaib Bin HassanMCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBAMy Blogwww.aureus-salah.comRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBAMy Blogwww.aureus-salah.com |
|
|
|
|
|
|
|
|
Taking snapshot of VM causes Mirror to failover