BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-06-2006, 05:18 PM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Mar 2006
Model: 8703e
Carrier: Sprint
Posts: 156
Post Thanks: 0
Thanked 1 Time in 1 Post
Default Move SQL to remote box

Please Login to Remove!

We tried to move SQL off locally and point BES 4.0 to the new remote SQL box last night with no luck. The new remote sql server is Windows 2003 and SQL 8.0. sp3. The BES has Windows 2000. We followed the steps from KB 03112, but when changing the DB server name and hitting next it came back with "DB upgrade failed. Error executing a SQL statement".

Now, we found and article on that statement but it was for 4.1 and made no sense.

Any ideas
__________________
Your BlackBerry Did What!!
Outlook 2010
BES 5
Offline  
Old 06-06-2006, 05:28 PM   #2 (permalink)
Thumbs Must Hurt
 
Join Date: Dec 2005
Location: Union NJ
Model: 8700
Carrier: TMobile
Posts: 59
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Try this, delete the database you moved to the SQL server. Then in the BES server configuration screen change your SQL server name....this will create a blank (empty) BESMgmt database on the SQL box. THEN restore your .bak (or however you're moving the current SQL database) file to that NEWLY created BESMgmt. This will populate the newly created BESMgmt on the SQL server with all the appropriate data from the old SQL box/install.
Offline  
Old 06-08-2006, 09:03 AM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Mar 2006
Model: 8703e
Carrier: Sprint
Posts: 156
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

Tried it again last night. no luck. Had to escalate with RIM experts and waiting for call.

We tried pointing the BES to another sql box with the 2000 windows server. No luck..

What a strange error.. Anyone ever ran into this..
__________________
Your BlackBerry Did What!!
Outlook 2010
BES 5
Offline  
Old 06-08-2006, 10:35 AM   #4 (permalink)
Thumbs Must Hurt
 
Join Date: Dec 2005
Location: Union NJ
Model: 8700
Carrier: TMobile
Posts: 59
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Did you allow the BES configuration to create a blank BESMgmt database on your new SQL box, then restore your current BESMgmt into the newly created database?

I just ask because we recently did a knife-edge cutover to a new server and SQL server and got the same message. We already had restored the current BESMgmt to the new SQL server then tried pointing the BES server config page to the new SQL server and got the same error. Only by removing the BESMgmt from the new SQL box and allowing the BES server config screen create a blank BESMgmt then restoring the data into the DB did things start working......
Offline  
Old 06-08-2006, 02:22 PM   #5 (permalink)
Thumbs Must Hurt
 
Join Date: Mar 2006
Model: 8703e
Carrier: Sprint
Posts: 156
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

Awesome, That worked.

So tonight we are going to move a copy of the active DB into the blank DB and cross our fingers.

The new bes has a new computer name. During the install of bes it asked for the server name and I put the old bes name in. That is our only other concern.. heard that would work without having to reactivate,
__________________
Your BlackBerry Did What!!
Outlook 2010
BES 5
Offline  
Old 06-08-2006, 03:02 PM   #6 (permalink)
Thumbs Must Hurt
 
Join Date: Dec 2005
Location: Union NJ
Model: 8700
Carrier: TMobile
Posts: 59
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

You MUST keep the BES server name the same....the computer name can be different.
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.