BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 07-10-2006, 02:30 PM   #1 (permalink)
New Member
 
Join Date: Jul 2006
Model: 7250
Carrier: Telus
Posts: 3
Post Thanks: 0
Thanked 0 Times in 0 Posts
Question Database Update Question?

Please Login to Remove!

Hi,

I am using BES 4.0 in my company, and we have more than 300 users now. I am going to upgrade the database from MSDE 2000 to SQL 2000. Can I just run the SQL2000 installation to do the upgrade?

Thanks!

Last edited by ggwinjack : 07-10-2006 at 03:49 PM.
Offline  
Old 07-11-2006, 11:17 AM   #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

I dont know but I would get a backup of the database:

DOS
c:\osql -E
1> backup database besmgmt to disk="c:\backup.bak"
2> go

And then once you get it install just attach the database back.

Done Done, and Done!
__________________
Cheers,
Ash


My BlackBerry GPS Golf Application | Mileage Calculator
Offline  
Old 07-24-2006, 05:23 AM   #3 (permalink)
New Member
 
Join Date: Jun 2006
Model: 9300
Posts: 4
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

ash... i found on installation guide something like: "Runnig a manula backup before the upgrade does not backup all parts of the schema..."
how can i be sure that the backup that you suggest it is ok ?
Thanks in advance.
Offline  
Old 07-24-2006, 12:50 PM   #4 (permalink)
Thumbs Must Hurt
 
Join Date: Jul 2006
Model: 7290
Carrier: Rogers In Canada - Cingular in US
Posts: 127
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

"Can I just run the SQL2000 installation to do the upgrade?"
Are you planning to install SQL on the same box as the BES?

Schema and references info is stored in the model and master dbs.
So yes its not backed up.

Hence once you do the back up,
On the SQL box run createdb.exe (look in the database folder under BES directory)

Look for creating BEMgmt database manually on the RIM Knowledgebase

Make sure the account has proper permissions on SQL server.

It take to 10 -15 mins.. Good Luck
Offline  
Old 07-24-2006, 12:52 PM   #5 (permalink)
Thumbs Must Hurt
 
Join Date: Jul 2006
Model: 7290
Carrier: Rogers In Canada - Cingular in US
Posts: 127
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

" And then once you get it install just attach the database back.

Done Done, and Done! " NOT DONE (wont work)

You will not be able to start service and will get Error 5608

Don't forget to run createdb.exe (To create the Schema on the SQL Box)
Then restore the backup.. or just attach the BESMgmt.mdf and ldf

Now its done
Offline  
Old 07-26-2006, 10:58 PM   #6 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2005
Model: 6230
Posts: 74
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I find it easier to use the BES config tool to create a new blank BES db, which upgrades the schema in the new DB server, and then simply restore the backup of the BES db originally created. Easier, straight forward, and less room for mistakes.
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.