Results 1 to 8 of 8

I'm preparing to retire my old SQL 2000 server and install a new SQL 2000 ... Server Admins forum

  1. #1
    JoelC's Avatar
    JoelC no está en línea Stack level 1
    Join Date
    Oct 2006
    PIN/ID
    23D81EB0
    Posts
    13

    move BESMgmt database from old SQL2000 to new SQL2000

    Advertisement



    I'm preparing to retire my old SQL 2000 server and install a new SQL 2000 server. How do I move the BESMgmt database so that my BES (on a separate dedicated server) still functions correctly?

    thanks,
    Joel
    </SPAN>

  2. #2
    berry-buster's Avatar
    berry-buster no está en línea BES Pro
    Join Date
    Aug 2007
    Posts
    118

    Re: move BESMgmt database from old SQL2000 to new SQL2000

    Will the new SQL Server have the same computer name as the old SQL Server?

  3. #3
    tlowe's Avatar
    tlowe no está en línea BES Pro
    Join Date
    Oct 2007
    Posts
    66

    Re: move BESMgmt database from old SQL2000 to new SQL2000

    I would say do a backup of the database then detach and move the database to the new server. You have to make the changes I believe in the balckberry conf

  4. #4
    JoelC's Avatar
    JoelC no está en línea Stack level 1
    Join Date
    Oct 2006
    PIN/ID
    23D81EB0
    Posts
    13

    Re: move BESMgmt database from old SQL2000 to new SQL2000

    The SQL server will have a different name (I'm actually weighing the benefits or issues of creating a new name or having the same name on the new SQL server....after disconnecting the old server from the domain)

    I figured that I would need to do a SQL backup of the database, but I really need some step-by-step instructions on moving the database to a new server, assuring that the BES server will still work properly.

    Joel

  5. #5
    tlowe's Avatar
    tlowe no está en línea BES Pro
    Join Date
    Oct 2007
    Posts
    66

    Re: move BESMgmt database from old SQL2000 to new SQL2000

    To me it looks like shutdown the BES server, backup and detach the database. Move the database to the new server attach the database. Bring up the BES server goto blackberry server configuration and click on change database, then test the sql server connection. That should bring you up fully,.

  6. #6
    jason1114's Avatar
    jason1114 no está en línea Stack level 2
    Join Date
    Sep 2006
    Posts
    83

    Re: move BESMgmt database from old SQL2000 to new SQL2000

    The process that tlowe explains is how we have done this in the past and work well for our company

  7. #7
    Crewdawg257's Avatar
    Crewdawg257 no está en línea BES Pro
    Join Date
    Jul 2006
    Posts
    248

    Re: move BESMgmt database from old SQL2000 to new SQL2000

    tlowe has posted an accurate description of the procedure.
    --
    I suspect that Microsoft Access is nothing but Microsoft Excel with a VBScript wrapper.
    - Unknown

  8. #8
    kentrg's Avatar
    kentrg no está en línea BES Pro
    Join Date
    Apr 2007
    PIN/ID
    246FBBBA
    Posts
    1,076

    Re: move BESMgmt database from old SQL2000 to new SQL2000

    Move the BlackBerry Configuration Database to another SQL Server

    Here you go

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
  •