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 |
|
pithhelmet
Posting Yak Master
183 Posts |
 Posted - 2007-11-05 : 14:05:00
|
| Hi everyone,The owners are on this 'virtual machine' kick (again)In a HA setup (principal, mirror, witness) can the mirror and witness be on a single machine using a VM setup??I know this is FAR from a great idea, but they wanna cut corners on hardware, again!!!thankstony |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-05 : 14:09:52
|
| What type of database mirroring do you intend to use? We use asynchronous database mirroring without a witness for performance reasons.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2007-11-05 : 14:23:17
|
| Hi Tara,Thanks for the response.The performance is truly not a problem, as the front end application is written in MS Access.I just need to have a five nines solution on paper for the SLA To answer your question, i was thinking of"principal and mirror servers operate in a synchronous transfer mode"The machines will be within reach of each other (3 1u machines sitting on top of each other)The DR will be in texas or someplace out west, so i was thinking of transaction log shippingfor the underpowered DR site. |
|
|
|
|
|
|
HA setup and virtual machines