BlackBerry Forums Support Community

Closed Thread
LinkBack Thread Tools
Old 05-23-2006, 10:12 AM   #1 (permalink)
New Member
Join Date: May 2006
Model: 8700
Posts: 1
Post Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy BES 4.0 - moving SQL database to different server

Please Login to Remove!

I wonder if anyone can help.

I have this scenario:

A single BES 4.0 server (SERVERA) connecting to a Microsoft SQL server (SQLSERVER1). This is working fine.

I would like a Disaster Recovery solution whereby we can failover the BESMgmt MS SQL database from SQLSERVER1 to a completely separate SQLSERVER2

SQLSERVER2 has an exact replica of the BESMgnt MS SQL database on SQLSERVER1

What procedure should we use to re-point the BES server SERVERA to use the BESMgnt SQL database on SQLSERVER2?

When we try to repoint the BES server to the SQL database on SQLSERVER2 it is failing with a "Failed to upgrade DB" error message.

Any ideas?????
Old 05-23-2006, 10:46 PM   #2 (permalink)
Knows Where the Search Button Is
Join Date: Mar 2006
Model: 7290
Posts: 29
Post Thanks: 0
Thanked 0 Times in 0 Posts

You need to go into Server Config for BlackBerry and change the database this will ask you for the servers name which you'll need to change. Once you've done this you need to go into BlackBerry Manager and change the database name on the server properties in there as well.

Copyright 2004-2016
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.