BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-14-2008, 10:34 AM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Aug 2008
Model: 9900
PIN: N/A
Carrier: O2 UK
Posts: 29
Post Thanks: 3
Thanked 2 Times in 2 Posts
Smile SQL move / knife edge cutover queries

Please Login to Remove!

Hi.

Been lurking on here as a guest for a while and recently signed up. Seems a great site. I'd appreciate it if you could help with some of my queries.

Scenario:

Currently running BES 4.0.7 with MSDE 2000 on ageing hardware and need to improve performance. We have 250 BB users across 5 Exchange 2003 mailbox servers. Main problem is limitations of MSDE, i.e. 2 messaging agents and 8 concurrent queries.

Plan:

1) Install JDBC for SQL on BES and move MSDE DB to an external SQL (2005) server, using documented procedure on blackberry.com. Increase messaging agents to 5 in registry on BES.

2) When happy that step 1 works and is performant, install BES 4.0.7 on new hardware and perform knife edge cutover.

3) At a later date - upgrade to BES 4.1.

Questions:

Where are the CALs stored? Are they in the SQL DB, or will I need to re-enter them all in the 'new' BES.

Same question for policy - is this in the DB?

Should I put the attachment service on a different server too?

Will BES take advantage of more than 1 CPU?

I'm sure I had another question, but can't think what it was now!!

Thanks in advance,

Chris.

Last edited by ctpuk : 08-14-2008 at 10:35 AM.
Offline  
Old 08-14-2008, 10:49 AM   #2 (permalink)
BlackBerry Extraordinaire
 
gibson_hg's Avatar
 
Join Date: Dec 2007
Model: NA
PIN: 80081ES
Carrier: NA
Posts: 1,006
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

You don't need to install JDBC to move the DB.

Here is RIM's KB on moving from MSDE to SQL:

BlackBerry Search Results

The CAL's and policies are in the DB and you do not need to move the attachment service to another machine. The BES should not need to use more than 1 CPU anyways. It's not designed as a resource hog
Offline  
Old 08-14-2008, 10:50 AM   #3 (permalink)
BlackBerry Extraordinaire
 
gibson_hg's Avatar
 
Join Date: Dec 2007
Model: NA
PIN: 80081ES
Carrier: NA
Posts: 1,006
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Welcome to BBF by the way
Offline  
Old 08-14-2008, 10:53 AM   #4 (permalink)
Knows Where the Search Button Is
 
Join Date: Aug 2008
Model: 9900
PIN: N/A
Carrier: O2 UK
Posts: 29
Post Thanks: 3
Thanked 2 Times in 2 Posts
Default

Thanks for the reply and the welcome!

The reason I mentioned the JDBC because it's listed as a pre-requisite for a new installation if you're using an external DB. If I'm understanding you correctly, then presumably due to the fact that MSDE is installed locally, the appropriate components already exist on the system to connect to a remote DB?

Thanks,

Chris.
Offline  
Old 08-14-2008, 10:56 AM   #5 (permalink)
BlackBerry Extraordinaire
 
gibson_hg's Avatar
 
Join Date: Dec 2007
Model: NA
PIN: 80081ES
Carrier: NA
Posts: 1,006
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Pretty much, I have not had to install JDBC in quite some time and I have not heard of anyone doing that as well. You could install JBDC if you want, it's up to you and it won't cause any issues with the DB.
Offline  
Old 08-14-2008, 10:59 AM   #6 (permalink)
Knows Where the Search Button Is
 
Join Date: Aug 2008
Model: 9900
PIN: N/A
Carrier: O2 UK
Posts: 29
Post Thanks: 3
Thanked 2 Times in 2 Posts
Default

Great! Thanks.
Offline  
Old 08-19-2008, 11:01 AM   #7 (permalink)
Knows Where the Search Button Is
 
Join Date: Aug 2008
Model: 9900
PIN: N/A
Carrier: O2 UK
Posts: 29
Post Thanks: 3
Thanked 2 Times in 2 Posts
Default

MSDE to SQL 2005 move went great. Came straight back up, no probs!

I increased messaging agents to 5 and performance is way better with far shorter last contact times to devices now.

I'm going to do the knife edge cutover tomorrow.

Here's my plan...

* Build new server.
* Install BES 4.0.7 with same BlackBerry Server name.
* Stop and disable BES services on old BES.
* Amend IP reservation so new BES takes IP of old BES (this makes life much simpler in my environment - for MDS and SRP routing out to Internet).
* Start BES services on new BES

Couple of questions...

Does it matter what IP address the server has when I actually install BES? I.e. should I change the IP reservation before I install it.

Do I need the JDBC for SQL on this installation because it's a new install?

On the blackberry.com knife edge cutover documentation, it mentions the MDS...

Quote:
Additional Info
When using BlackBerry® Mobile Data System (BlackBerry MDS) Services, you must create a new mdss and mdss_dis database. A knife-edge cutover of the BlackBerry MDS Services is not supported.

Note: MDSS is supported only if the BlackBerry Enterprise Server name is not changed.
What does this mean? And how do I create the new DB?

Thanks in advance and thanks for all advice so far.

Chris.

Last edited by ctpuk : 08-19-2008 at 11:03 AM.
Offline  
Old 08-19-2008, 01:11 PM   #8 (permalink)
BlackBerry Extraordinaire
 
gibson_hg's Avatar
 
Join Date: Dec 2007
Model: NA
PIN: 80081ES
Carrier: NA
Posts: 1,006
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

The MDS Services is only in version 4.1 and up. Seeing as you will be installing 4.0 you don't need to worry about it. Also, the BES is not concerned with IP or machinename, just the logical BES name in the manager.

MDS Services is basically a web server that you post your own custom made apps to for BB and your users can install the MDS software on their BB to browse and install any of the apps you post. Most places that install MDS Services do not use and probably never will. I wouldn't worry about it.

You can install JDBC if you want but it shouldn't be necessary.

You're plan is fine, keep on course and ask any questions if you're unsure about something.
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.