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:10:36
|
| Hi everyone,Do the mirror and witness machines need to be the exact same equipment level as the principal???thankstony |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-05 : 14:12:25
|
| No.I'd recommend for a DR server that the principal and mirror be the same though. Imagine that your mirror server has lesser hardware than the principal and a disaster situation occurs. Can your mirror hardware support production?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2007-11-05 : 14:34:12
|
| Hi Tara,Nope - the SLA states that in a failed situation, the performance will be degraded.The mirror shouldn't have to work for too long in a production role,(i would hope) but it shouldn't be in that role for more than 4 hours.but the DR site should be the same as the primary site - but we'll see where that statement goes LOLthanktony |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-05 : 14:45:22
|
| You can't make assumptions on how long the mirror would be in use for production as there are varying degrees of a disaster. Your plan should include options where the primary site is completely gone. If you've got a very small application and database, then it probably won't matter how small of a server is at the DR site.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2007-11-05 : 15:07:31
|
| Right - Hurricane Noel (LOL) put the 'fear of god' in the new and improved management team, and now everything is DR DR DR DR.... |
|
|
|
|
|
|
HA Machine reqs