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
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, 07: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

Mini Pocket LCD Digital Multimeter DC/AC Voltmeter DC Ammeter Tester US ship
$13.1
Mini Pocket LCD Digital Multimeter DC/AC Voltmeter DC Ammeter Tester US ship pictureAmp Gauge Ammeter for Farmall IH Cub A AV B C H M MD I6 W4 W6 Supers 3544 (2Nos)
$14.0
Amp Gauge Ammeter for Farmall IH Cub A AV B C H M MD I6 W4 W6 Supers 3544 (2Nos) pictureAntique Electric General Electric 6" AC Ammeter Steampunk
$44.99
Antique Electric General Electric 6Antique Electric General Electric 6" AC Ammeter #2 Steampunk
$34.99
Antique Electric General Electric 6Flexzion Digital Multimeter Voltmeter Ammeter Ohmmeter Multi Tester Handheld Too
$8.0
Flexzion Digital Multimeter Voltmeter Ammeter Ohmmeter Multi Tester Handheld Too picture






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