Results 1 to 5 of 5

Hello. I am looking for some help with upgrading my existing BES from MSDE to ... Server Admins forum

  1. #1
    james.cooney's Avatar
    james.cooney no está en línea Stack level 1
    Join Date
    Feb 2007
    Posts
    3

    Upgrade BES 4.1 from MSDE to SQL

    Advertisement



    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.

  2. #2
    hayden's Avatar
    hayden no está en línea Stack Mod
    Join Date
    Jul 2004
    PIN/ID
    ask
    Posts
    12,440

    Re: Upgrade BES 4.1 from MSDE to SQL

    Welcome to Pinstack...

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

  3. #3
    james.cooney's Avatar
    james.cooney no está en línea Stack level 1
    Join Date
    Feb 2007
    Posts
    3

    Re: Upgrade BES 4.1 from MSDE to SQL

    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.

  4. #4
    james.cooney's Avatar
    james.cooney no está en línea Stack level 1
    Join Date
    Feb 2007
    Posts
    3

    Re: Upgrade BES 4.1 from MSDE to SQL

    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

  5. #5
    wizkid1981's Avatar
    wizkid1981 no está en línea BES Guru
    Join Date
    Jan 2007
    Posts
    113

    Re: Upgrade BES 4.1 from MSDE to SQL

    Great information and very detailed. Thanks!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •