BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 10-05-2010, 07: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

1Pcs 6Es5451-7La12 Good Quality Brand New Plc Siemens N
$881.94
1Pcs 6Es5451-7La12 Good Quality Brand New Plc Siemens N pictureSiemens SICAM 6MD1023-0AA00 Command Release Module E.Stand 12 New
$1619.26
Siemens SICAM  6MD1023-0AA00  Command Release Module  E.Stand 12  New  pictureNEW SIEMENS 125 HP ELECTRIC MOTOR RGZEESD 460V 444TS FRAME 143A 1785RPM TYPE F
$4999.99
NEW SIEMENS 125 HP ELECTRIC MOTOR RGZEESD 460V 444TS FRAME 143A 1785RPM TYPE F picture1Pcs New 6Se6400-0Ap00-0Aa1 Micromaster 4 Siemens Operator Panel A
$253.96
1Pcs New 6Se6400-0Ap00-0Aa1 Micromaster 4 Siemens Operator Panel A pictureUsed 1Pcs Simatic 6Es5390-0Ua11 Siemens Td390 Plc Module A
$484.99
Used 1Pcs Simatic 6Es5390-0Ua11 Siemens Td390 Plc Module A picture






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