BlackBerry Forums Support Community               

Closed Thread
LinkBack Thread Tools
Old 06-26-2009, 07:50 AM   #1 (permalink)
Knows Where the Search Button Is
Inzomniak's Avatar
Join Date: Sep 2008
Location: Devon, UK
Model: Bold
PIN: 2566****
Carrier: O2-UK
Posts: 22
Post Thanks: 0
Thanked 0 Times in 0 Posts
Question BES SQL Database migration to SQL Cluster

Please Login to Remove!

I have ran into an issue whilst migrating the BlackBerry SQL database from our BES server to our SQL Cluster, I have been following the RIM KB03112 - How to move the BlackBerry Configuration Database to a new Microsoft SQL Server instance.

I have ran through the document, when I get Task 4 - Configure the BlackBerry Enterprise Server, For BlackBerry Enterprise Server software version 4.1, install the database notification system section, I have edited the NotifyInstall.sql file and replaced "_DATABASENAME_" with the name of our database "BESMgmt" and ran the script.

I got an error message advising that it could not continue as the database collations do not match, on investigation the BES database collation is set as Latin1_General_CP1_CI_AS, but the SQL Cluster collation is set as SQL_Latin_General_CP1_CI_AS, so for the time being we have rolled back the migration until we can find a way around this, any help would be appreciated.
Old 06-26-2009, 07:59 AM   #2 (permalink)
BlackBerry Genius
hdawg's Avatar
Join Date: Aug 2006
Model: hdawg
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts

Don't use the database notification system. It isn't needed for BES to function and honestly will only cause you more trouble at this point.
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

SY100-30-1A SMC NEW In Box Solenoid Valve Connector SY100301A
SY100-30-1A SMC NEW In Box Solenoid Valve Connector SY100301A picture24V/DC Solenoid Safety Valve
24V/DC Solenoid Safety Valve pictureASCO # 8551A001MS SOLENOID VALVE - NEW
ASCO # 8551A001MS SOLENOID VALVE - NEW pictureSolenoid Valve - ASCO Red Hat
Solenoid Valve - ASCO Red Hat pictureBobcat Solenoid Valve Part# 6672863
Bobcat Solenoid Valve Part# 6672863 picture

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