Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection



Reply
LinkBack Thread Tools Display Modes
BESMgmt SQL Database Mirroring
 
  #1 (permalink)  
Old 12-08-2009, 01:39 PM
BES Administrator
 
Join Date: Jan 2009
Location: Chicago
Posts: 44
Default BESMgmt SQL Database Mirroring

Got this setup under 5.0.1 with SQL 2005 Sp3. Failed over to the mirror and failed back without issue... however:

The RIM docs on mirroring state that the Dispatcher service updates the registry of the BES servers to modify the DatabaseServerMachineName value to the value of the mirror after failover. No such thing happened.

Supposedly you need to modify the FailoverServerMachineName value manually on each BES back to the original principal that failed, in order to cause that to be recognized as the mirror for failback.

None of this is needed apparently (which is awesome as failover/failback is seamless). I am using the Native SQL client and it appears all this magic is handled at that level.

Anybody else played with this? Is this just bad docs from RIM which refer to the older SQL replication, and does not apply to mirroring?
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 12-08-2009, 10:49 PM
Otto's Avatar
Proprietor
 
Join Date: Nov 2008
Location: Atlanta, GA
Posts: 2,033
Blog Entries: 14
Default

I had the same experience as you with BES 5.0.0 - no issues. I've thought about using CNAME entries for the database mirroring piece in order to avoid any sort of backend server name issues, but I haven't looked at it too much (this is what we do for some of our mirroring configurations). FWIW, as of 5.0.1, they also mention that you must have SQL 2005 Enterprise, although Standard works just fine. I think they have a lot of issues with their documentation (although it's gotten better, which is the scary thing). At least they finally corrected the 'SQL 2003' mistakes from the 5.0 documentation
__________________
BCSA (4.1, 5.0) | BCSD (4.1, 5.0)

The views expressed by me on Port3101.org are my own and do not necessarily reflect the views of my employer.
Reply With Quote
  #3 (permalink)  
Old 12-09-2009, 04:04 PM
BES Administrator
 
Join Date: Jan 2009
Location: Chicago
Posts: 44
Default

After further testing, I can conclusively say that...

...I have reached the promised land!

Seamless failover/failback of BES active/standby pair as well as to SQL mirror! Woot!

How long have I waited for this day...
Reply With Quote
  #4 (permalink)  
Old 12-09-2009, 10:15 PM
BES Expert
 
Join Date: Mar 2009
Posts: 106
Default

SQL Enterprise edition provides for asynchronous mirroring, whereas Standard does not. Docs should state support for both and any limitations/benefits which each version. Asynchronous provides for better SQL performance.
Reply With Quote
  #5 (permalink)  
Old 12-09-2009, 10:22 PM
BES Activated
 
Join Date: Aug 2009
Location: Oz
Posts: 8
Default

So what do you change?
Reply With Quote
  #6 (permalink)  
Old 03-03-2010, 12:31 PM
BES Activated
 
Join Date: Mar 2010
Location: Maryland
Posts: 1
Default Database Mirroring

All,

Sorry but I've followed the instructions I have found for setting up a SQL 2005 mirror but

I belive I keep doing the restore wrong. I have gotten the the mirror to work but only when the mirrored database is still in a (Restoring..) state.

Any one have any ideas?
Reply With Quote
  #7 (permalink)  
Old 03-04-2010, 09:39 AM
noname's Avatar
BES Administrator
 
Join Date: Apr 2009
Location: Congested Islet of Foreign Talents (42% of population) - Singapore.
Posts: 24
Default

I do noticed that FailoverServerMachineName never get updated during a SQL failover. Did not know about DatabaseServerMachineName; now I know. Thanks mahoward.
__________________
【noname】- Native but 3rd class citizen of a nation governed by idiots who import congestions and contention.
BlackBerry® Certified Solution Designer + System Administrator
IBM Certified Advanced Application Developer + Associate System Administrator - Lotus Notes and Domino
Reply With Quote
  #8 (permalink)  
Old 03-05-2010, 06:29 PM
noname's Avatar
BES Administrator
 
Join Date: Apr 2009
Location: Congested Islet of Foreign Talents (42% of population) - Singapore.
Posts: 24
Default

Question for mahoward:

During your SQL failover, what is displayed as the SQL SeverName field when you check the BlackBerry Server Configuration panel under the Database Server tab? If it still pointing to old SQL server? Or has it changed to the newly prmoted principal SQL server?
__________________
【noname】- Native but 3rd class citizen of a nation governed by idiots who import congestions and contention.
BlackBerry® Certified Solution Designer + System Administrator
IBM Certified Advanced Application Developer + Associate System Administrator - Lotus Notes and Domino
Reply With Quote
Reply

Thread Tools
Display Modes

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Script to perform a scheduled BESMgmt Database backup hdawg Scripts & Tools / Hints & Tricks 10 08-04-2011 08:06 AM
Importing an SQL Besmgmt database over the top arthurlandry Port 3101: The BES Admin Bar & Grill 0 04-27-2010 03:58 PM
KB03112 - How to move the BESMgmt Database to a new SQL Server or instance hdawg Featured BlackBerry KB Articles 9 03-11-2010 01:49 AM
KB03543 - Unable to open BESMgmt database hdawg Featured BlackBerry KB Articles 0 09-24-2009 04:24 PM
KB11209 - The SQL transaction log file for the BESMgmt database on SQL is full hdawg Featured BlackBerry KB Articles 0 08-23-2009 08:53 PM


All times are GMT -4. The time now is 04:21 AM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2019, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2