BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 10-05-2010, 08:10 AM   #1 (permalink)
Thumbs Must Hurt
 
elbutre's Avatar
 
Join Date: Oct 2006
Location: London
Model: 9700
Carrier: vodafone
Posts: 75
Post Thanks: 2
Thanked 2 Times in 2 Posts
Default bes 5.0 ha sql mirror placement of witness server

Please Login to Remove!

hi

i have 2 sites, our office and our DR site

i have 1 bes 5 primary server with sql server 2008 r2 principal besmgt database running in our office

i have 1 bes 5 standby server with sql server 2008r2 with besmgt mirrored.

i have also setup a 3rd sql express 2008 r2 in our DR site and use this as a witness server.

i am debating whether to put the witness server in our DR site or our office.

for instance if it is in our office and our office site goes down i cannot failover to the DR site sql server so i placed it in our DR site which means that SQL and bes both failover automatically.

but on the other hand this creates a situation if the DR site becomes inaccessible the principal sql database detects that both the mirror and witness server are not accessible and it goes into a standby mode. luckily the bes server remains operational even with the sql database being in the state it is in.

we only have 21 users so there is no way i am going to run sql and bes on separate servers and it would also still not solve the issue where to place the witness server.

my current thinking is to keep it in the DR site as this will:
a) enable me to failover automatically to the DR site if needed
b) if DR site goes down the bes server in the office still remains up and running even though the besmgt database goes into a standby state, i guess as long as you do not restart bes services it should be okay.

could you let me know where you have placed your witness server.

i do have an option btw to place the witness server at a 3rd site completely separate from the office and the DR site so perhaps that is the best solution?

cheers
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.