[james.cooney]

Hello.
I am looking for some help with upgrading my existing BES from MSDE to SQL.
We have exceeded RIM's recommended threshold for the MSDE and are having problems related to the MSDE limitation of 2 Mailbox Agents.

I have not been able to locate any solid documentation thus far. Any help would be greatly appreciated.

Thanks.

[hayden]

Welcome to Pinstack...

Try this thread:
http://blackberryforums.pinstack.com..._msde_sql.html

[james.cooney]

Thank you
i was able to get it work. I will post the procedure on Monday. it is very close to what you linked me to.

[james.cooney]

Here it is, in case anyone else needs to do this...
Upgrade BES 4.1 from MSDE to SQL2000 on the same server

Stop All Blackberry Services
From a command prompt, backup the MSDE Database to Disk
Switch to the directory where BESMgmt exists
osql
1> BACKUP DATABASE BESMgmt TO DISK = ‘C:\backup.bak’
2> go
3> quit
Stop MSSQL and MSSQLAgent Services
Copy BESMgmt.mdf and BESMgmtlog.ldf to another location
Start MSSQL andMSSQLAgent Services
Go back to the Command prompt window, and switch to the MSSQL directory
osql –E
1> drop database BESMgmt
2> go
(Note) this will drop and delete the BESMgmt database from MSDE. Make sure you backed it up!!!!!!!!
Install SQL Server 2000 and necessary Service Packs
Open SQL Enterprise Manager
Navigate to SQL Server Group/SQL Server Name/Security
Right Click Logins and select New Login
On the General Tab, click on the … Button
Select the name of you Blackberry Service Account
On the Server Roles Tab, select Server Administrators and Database Creators
Close SQL Enterprise Manager
Click Start/Run
svrnetcn
Make sure TCP/IP and Named Pipes are both listed and enabled protocols
From the BES 4.1 Installation CD/Directory, copy the Database directory to the local Hard Drive
Open a Command prompt and switch to the Database directory that you just copied
createdb.exe BESMgmt.cfg
(this will expand the Schema of the SQL Server Install)
Copy the BESMgmt.mdf and BESMgmtlog.ldf to the MSSQL\Data Directory
Re-Open SQL Enterprise Manager
Right click on the BESMgmt database and click Detach Database
Navigate to the SQL Data directory and rename the BESMgmt.mdf and BESMgmtlog.ldf to .old
Copy in to that same directory the BESMgmt.mdf and BESMgmtlog.ldf backed up from before
In SQL Enterprise Manger, right click Database and click All Tasks/Attach Database
Browse to the newly copied BESMgmt.mdf and select it
It should automatically find the BESMgmtlog.ldf file
Open Blackberry Server Configuration
On the database connectivity tab, select Change Database
Go thru the wizard and make sure at the end Start Services is checked
Open Blackberry Manager and verify all looks good
Test message flow

[wizkid1981]

Great information and very detailed. Thanks!