BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-14-2005, 09:07 PM   #1 (permalink)
New Member
 
Join Date: Mar 2005
Model: 8830
Carrier: sprint
Posts: 6
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default A little help with error after moving from MSDE to SQL

Please Login to Remove!

Moved db from BES server local MSDE to our SQL server. Attached database, changed db server in BEServer Manager and BEServer Config. When services restarted I have the following error-

Database schema is not not complete. Run Config tool to update it
Stopping BlackBerry

Trying to start the Dispatcher service. It then stops.


BES 4.0, Exchange 2000. Previous to the db move everything was working fine.
I followed these directions to move the db-


Simple really. Shut down the BES services and stop msde. Find the besmgmt ldf and mdf files on the msde machine and copy them to the data directory of the sql machine. Then open up SQL manager and attach those databases (right click attach database if i recall). Then fire up BES mgmt console (it may say cant connect to db) and point it towards the new database. Start services and should be cool.
just remember there are 2 places to change settings for the BES. one is in BlackBerry Manager and the other is in BlackBerry Server Configuration (i think thats the right name... both are in the start menu). the latter is the main place to change it (or you can do as greywolfe stated), but the first one will have to be changed if you want to get the correct information in BB Manager or Handheld Configuration Tool.
Offline  
Old 06-15-2005, 12:30 PM   #2 (permalink)
New Member
 
Join Date: Jun 2005
Model: 7290
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Change owner

Change the owner of the db to the blackberry user.
Offline  
Old 06-15-2005, 12:39 PM   #3 (permalink)
New Member
 
Join Date: Mar 2005
Model: 8830
Carrier: sprint
Posts: 6
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

db owner is/was correct

I searched Blackkberry's site and could not find that error. Not sure what "Config tool" it is refering to above and beyond running the BES configuration wizard. I will have to open a call with them. I reverted back to the MSDE db in the mean time...
Offline  
Old 06-15-2005, 05:57 PM   #4 (permalink)
Thumbs Must Hurt
 
Join Date: Mar 2005
Location: Denmark
Model: 7230
Carrier: TDC
Posts: 102
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by sparticat
db owner is/was correct

I searched Blackkberry's site and could not find that error. Not sure what "Config tool" it is refering to above and beyond running the BES configuration wizard. I will have to open a call with them. I reverted back to the MSDE db in the mean time...

had the same issue with a domino version , doing some testing tomorrow to see what i can be caused by.
Offline  
Old 06-15-2005, 06:59 PM   #5 (permalink)
Talking BlackBerry Encyclopedia
 
greywolfe's Avatar
 
Join Date: Mar 2005
Location: NSW, Australia
Model: 8100
Carrier: optus
Posts: 303
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Tried running setup again from add/remove programs?
__________________
BES Admin, sometime God.
Offline  
Old 06-15-2005, 10:14 PM   #6 (permalink)
Knows Where the Search Button Is
 
Join Date: Apr 2005
Location: SE Michigan
Model: 7100T
Carrier: T-Mobile
Posts: 17
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I just got through the same problem. Here's what to do:

1. Shut down BES servers.

2. On the MSDE server, run OSQL -E (if using windows nt authentication) or OSQL -U <username> -P <password>

> BACKUP database BESMgmt TO DISK = "c:\BESMgmt-backup.bak"
> Go

3. Detach the BESMgmt database from the SQL server
4. Delete the BESMgmt from the file system.
5. Run the BlackBerry Server Configuration from the BES server
6. Enter the SQL server name and BESMgmt for db name. Make sure the SQL ID has db create rights in SQL. You don't have to go through the entire setup by adding the SPR and such. Just enough to create the db.
7. On the SQL server, restore the BESMgmt backup over the BESMgmt database. Right click on the db and select All Tasks - Restore
8. Create whatever user and servre IDs you need, making sure they are in the bes server role, can't recall the exact name.

Then you should be golden. Apparently BES makes some changes to the master table in SQL, which is why just moving the database isn't enough.
Offline  
Old 06-15-2005, 10:54 PM   #7 (permalink)
New Member
 
Join Date: Mar 2005
Model: 8830
Carrier: sprint
Posts: 6
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

thanks pista- I will give this a shot over the weekend.
Offline  
Old 06-16-2005, 11:49 PM   #8 (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

sparticat, i just went through some steps in order to do a HOWTO for the forum. i'm posting it now. mine is for SQL to SQL server migration, but it should be the same from MSDE 2000 to SQL 2000.

pista is correct on all accounts, except 3 and 4 wouldn't necessarily be needed.
__________________
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 06-17-2005, 12:30 AM   #9 (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

pista, see if you have anything to add/change from this:

HOWTO: Migrate MSDE2K or SQL2K database to new server
__________________
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  
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.