BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-08-2008, 09:29 AM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Jan 2006
Model: 7520
Carrier: Tmobile
Posts: 31
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default BES 4.1 Database move question..

Please Login to Remove!

I am moving from a remote SQL2000 server to a remote SQL2005 cluster\instance. I am confused on whether or not I need to perform this step:

--

Step 4

Update the BlackBerry Configuration Database schema.

Important: If the BlackBerry Enterprise Server software was installed to create a blank BlackBerry Configuration Database on a new Microsoft SQL Server instance, do not perform the following task because the schema has already been updated.

Download the installation package for the version of the BlackBerry Enterprise Server being used.
Extract the contents of the installation package.
Copy the Database folder to the new Microsoft SQL Server.
Go to the Database folder and open the BESMgmt.cfg file in a text editor, such as Notepad.
Locate the DB_NAME=BESMgmt line and make sure that the name specified matches the BlackBerry Configuration Database name.
If you are using a named instance of Microsoft SQL Server, change the SERVER=local line to SERVER=<Microsoft_Server_Name>\ <instance_name> and close the file. Save the changes.
From a command prompt, go to the Database directory.
Type createdb.exe BESMgmt.cfg and press ENTER.
After the command has finished executing, close the command prompt.

--

Thanks!
Offline  
Old 08-08-2008, 09:59 PM   #2 (permalink)
CrackBerry Addict
 
ashworth's Avatar
 
Join Date: Jun 2006
Location: Ontario, Canada
Model: 9000
OS: 4.6
Carrier: Rogers
Posts: 625
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

You should run this step or else you could get a 5608 error message when trying to start the Dispatcher service. RIM stores error messsages within the sysmessages table within the master database and this step will add the customer errors for RIM.

(I have had this happen to me more then once)
__________________
Cheers,
Ash


My BlackBerry GPS Golf Application | Mileage Calculator
Offline  
Old 12-17-2008, 01:41 PM   #3 (permalink)
Thumbs Must Hurt
 
JavaJunkee's Avatar
 
Join Date: Jan 2007
Location: Seattle, WA
Model: 9780
Carrier: T-Mobile
Posts: 155
Post Thanks: 2
Thanked 0 Times in 0 Posts
Default

Why not just perform a "Restore Database" on the target (source), database server?

I just performed a test, and it works.

I've always been very confused by that document (KB03112 - How to move the BlackBerry Configuration Database to a new Microsoft SQL Server or instance).

To me, it's a bit hard to follow the bouncing ball and also seems to have you perform redundant tasks. For example, it has you create a schema, restore DB via command line and Detach DB, move *.mdf, *.ldf files, Attach DB.

Again, why not just 'Restore DB' via the GUI. It seems to cover it all.
Offline  
Old 12-17-2008, 02:47 PM   #4 (permalink)
BlackBerry Elite
 
knottyrope's Avatar
 
Join Date: Jan 2008
Location: Massachusetts
Model: Z30
OS: 10.2.1
PIN: t of blood has been taken
Carrier: AT&T-US with I dee ten tee errors
Posts: 6,645
Post Thanks: 264
Thanked 270 Times in 256 Posts
Default

If you dont use createbd.exe for the first time, the SQL server agent jobs do not get installed.
__________________
irony : many old timer posters have de-evolved into the trolls they once fought
I am on http://supportforums.blackberry.com
BES 10 running sweet for my Z30, Z10 and Q10
Offline  
Old 12-17-2008, 03:16 PM   #5 (permalink)
Thumbs Must Hurt
 
JavaJunkee's Avatar
 
Join Date: Jan 2007
Location: Seattle, WA
Model: 9780
Carrier: T-Mobile
Posts: 155
Post Thanks: 2
Thanked 0 Times in 0 Posts
Default

Ah,

Thx knottyrope

Silly that RIM doesn't include better info in their documentation.

Of course they do have a plethra of docs, so perhaps I missed one.
Offline  
Old 12-18-2008, 05:25 AM   #6 (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

Well, the move DB doc tells you to run createdb.exe if the DB does not yet exist. Most companies tech docs tell you steps for a reason but leave out issues caused if they are not specifically followed.

In this instance not running createdb.exe on a new server can cause 2 issues already mentioned: no sql jobs being created and entries are not placed in the sysmessages table resulting in a 5608 error on service start up.

When following a doc, follow the steps unless you are told that you can skip it if you meet certain criteria.
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.