BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 03-24-2008, 11:53 AM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Oct 2007
Model: 9700
PIN: N/A
Carrier: ATT
Posts: 52
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Moving to SQL

Please Login to Remove!

Hi all,

Due to some performance issue with MSDE, I will be switching to a SQL db. Has anyone done this before and could you share your experience?

My current setup...
One BES with 248 users,
Version 4.1.3 SP4
MSDE database

I'm a bit nervous doing this this. We have one BES production server and NO test server. Therefore, I will have to take it offline briefly, I hope, to do this. Any input is MUCH appreciated.

Thanks,
Rich aka Worried
Offline  
Old 03-24-2008, 12:02 PM   #2 (permalink)
New Member
 
Join Date: Feb 2007
Model: 8700
Carrier: T-mobile
Posts: 9
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Very easy...

Backup you DB
Stop all BES services
Install SQL, it should ask you to upgrade your existing installation... say yes.
Install SQL patches
Increase the number of available agents to 5 if you need to
Restart BES

It's been some time since I have done this, I think I had to re-run the install after the update to install the SQL manager, but that was just the modify part of the install.
Offline  
Old 03-24-2008, 01:31 PM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Oct 2007
Model: 9700
PIN: N/A
Carrier: ATT
Posts: 52
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by whyerd View Post
Very easy...

Backup you DB
Stop all BES services
Install SQL, it should ask you to upgrade your existing installation... say yes.
Install SQL patches
Increase the number of available agents to 5 if you need to
Restart BES

It's been some time since I have done this, I think I had to re-run the install after the update to install the SQL manager, but that was just the modify part of the install.

Thanks for the quick reply. I saw another thread with links on moving from MSDE to SQL. I'm follow those steps.

Any other good tips to know? Anyone?
Offline  
Old 04-10-2008, 03:32 PM   #4 (permalink)
New Member
 
Join Date: May 2005
Location: san francisco
Model: 7100t
Carrier: AT&T
Posts: 10
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Does this process appy to a situation where we want to breakout the DB to another server running SQL 2005?

We have one BES server running MSDE, and we want to break out the DB to another server. Would the above steps work so that I won't need to re-active all the handhelds?

thanks,
Mooge
Offline  
Old 04-11-2008, 05:03 PM   #5 (permalink)
New Member
 
thunderck's Avatar
 
Join Date: Feb 2007
Model: 8700g
Carrier: T-Mobile
Posts: 7
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Are you running Domino or Exchange? There are some KB articles you are going to want to look at depending which you are running and if the SQL is local to the BES or remote.

Last edited by thunderck : 04-11-2008 at 05:05 PM. Reason: Got a bit ahead of myself..
Offline  
Old 04-11-2008, 06:01 PM   #6 (permalink)
New Member
 
Flash's Avatar
 
Join Date: Jan 2006
Location: UK
Model: 8700
Carrier: Vodafone
Posts: 1
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

1. Install SQL Server on a separate server.
2. Copy the Database folder from the BES installer to the root of the C: drive on SQL.
3. Open command promt and got to database folder.
4. Type createdb besmgmt.cfg
5. This will create a blank BESMgmt database on your new SQL server however it ALSO improtantly installs the stored procedure into the SQL system database. This is important as if you just backup and restore youre database to the new SQL then these would be missing and your BES wont work.
6. Now you can restore the backup of youre production BES onto the SQL box.
7 Now back on you production BES point the BES to the new location.
8. You will also need to point BB Manager at the new DB as it will be pointing to the old DB.

There is a KB for this which gives more details than I have. I would have a look for it on BBs website.
Offline  
Old 04-11-2008, 06:18 PM   #7 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

Here you go. You will need to modify the cfg file to have the correct database name, if not BESMgmt, if I remember correctly.

BlackBerry Search Results
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Old 04-14-2008, 06:27 AM   #8 (permalink)
Thumbs Must Hurt
 
Join Date: Oct 2007
Model: 9700
PIN: N/A
Carrier: ATT
Posts: 52
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for all the tips guys. How long does this process usually take? In my environment, I dont have a test BES. Therefore, there will be downtime during the DB move. Just trying to have plan. Thanks again.
Offline  
Old 04-14-2008, 12:15 PM   #9 (permalink)
Knows Where the Search Button Is
 
Join Date: Aug 2007
Location: Spring, Texas
Model: 8830
PIN: N/A
Carrier: Sprint-Nextel
Posts: 25
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by Flash View Post
1. Install SQL Server on a separate server.
2. Copy the Database folder from the BES installer to the root of the C: drive on SQL.
3. Open command promt and got to database folder.
4. Type createdb besmgmt.cfg
5. This will create a blank BESMgmt database on your new SQL server however it ALSO improtantly installs the stored procedure into the SQL system database. This is important as if you just backup and restore youre database to the new SQL then these would be missing and your BES wont work.
6. Now you can restore the backup of youre production BES onto the SQL box.
7 Now back on you production BES point the BES to the new location.
8. You will also need to point BB Manager at the new DB as it will be pointing to the old DB.

There is a KB for this which gives more details than I have. I would have a look for it on BBs website.
I neglected to repoint my manager to the new database...... I didn't know I had a problem until I added a new user and the user was stuck on authenticating.
Offline  
Old 04-16-2008, 01:46 PM   #10 (permalink)
Thumbs Must Hurt
 
Join Date: Sep 2004
Model: 8800
Carrier: AT&T
Posts: 60
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

We just did this exact thing last week. It went pretty smooth. Everything everyone says is correct. Make sure you also get all of the MDS databases. Most people don't use MDS and that was a gotcha for me. We ended up having to uninstall/reinstall the BES because something was corrupt - but that took alot of the time. Ultimatley as long as you have your MSDE on your BES you can always revert back to that. If you have support you can call them up and they will sit on the phone with you while you do it. Should be pretty painless. Make sure you have a current copy of your install files handy just in case.

Ken
Offline  
Old 04-17-2008, 06:45 AM   #11 (permalink)
Thumbs Must Hurt
 
Join Date: Oct 2007
Model: 9700
PIN: N/A
Carrier: ATT
Posts: 52
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by Puddin View Post
We just did this exact thing last week. It went pretty smooth. Everything everyone says is correct. Make sure you also get all of the MDS databases. Most people don't use MDS and that was a gotcha for me. We ended up having to uninstall/reinstall the BES because something was corrupt - but that took alot of the time. Ultimatley as long as you have your MSDE on your BES you can always revert back to that. If you have support you can call them up and they will sit on the phone with you while you do it. Should be pretty painless. Make sure you have a current copy of your install files handy just in case.

Ken

Thanks for the feedback. I know its only been a week but have you seen any noticable improvements after switching to a SQL db?
Offline  
Old 04-17-2008, 07:04 AM   #12 (permalink)
Knows Where the Search Button Is
 
Join Date: Aug 2007
Location: Spring, Texas
Model: 8830
PIN: N/A
Carrier: Sprint-Nextel
Posts: 25
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I didn't notice any improvement, but I don't have a lot of BB users either. I did it just for the consolidation of sql databases on one big box.

Like Ken said, support will help you with it. Just don't forget to repoint your management console(s) to the new database.
Offline  
Old 04-17-2008, 07:05 AM   #13 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

... I'm also wondering if you've installed the DBNS (DataBase Notification Service) as a part of the move ...
Offline  
Old 04-17-2008, 12:08 PM   #14 (permalink)
Thumbs Must Hurt
 
Join Date: Sep 2004
Model: 8800
Carrier: AT&T
Posts: 60
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by RichieRichR6 View Post
Thanks for the feedback. I know its only been a week but have you seen any noticable improvements after switching to a SQL db?
Before the upgrade/move, I was receiving a tremendous amount of agent errors - this has been reduced dramatically. There was errors in the logs where MSDE couldn't handle the number of db connections. We have 300 users on the BES. After the upgrade mail was processed so much faster. I received many comments on how much faster the mail made it to the handhelds. Huge performance improvement.

Ken
Offline  
Old 04-17-2008, 01:23 PM   #15 (permalink)
Thumbs Must Hurt
 
Join Date: Oct 2007
Model: 9700
PIN: N/A
Carrier: ATT
Posts: 52
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by Puddin View Post
Before the upgrade/move, I was receiving a tremendous amount of agent errors - this has been reduced dramatically. There was errors in the logs where MSDE couldn't handle the number of db connections. We have 300 users on the BES. After the upgrade mail was processed so much faster. I received many comments on how much faster the mail made it to the handhelds. Huge performance improvement.

Ken
Sweet! I hope my user will appreciate it too.
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.