BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-26-2009, 08:50 AM   #1 (permalink)
Knows Where the Search Button Is
 
Inzomniak's Avatar
 
Join Date: Sep 2008
Location: Devon, UK
Model: Bold
OS: 4.6.0.266
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.
Offline  
Old 06-26-2009, 08:59 AM   #2 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
Offline  
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





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.