BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 02-02-2008, 11:50 AM   #1 (permalink)
New Member
 
Join Date: Oct 2007
Model: 8830
PIN: N/A
Carrier: verizon
Posts: 8
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Bes 4.1.25 upgrade from SQL2000 to SQL2005

Please Login to Remove!

We are upgrading our SQL 2000 server to SQL2005, this also happens to be our BES server that uses a 2000 SQL database. I ran the MS SQL 2005 upgrade advisor, which had the following upgrade issue:

Upgrade Advisor detected statements that reference undocumented system tables that are not available in SQL Server 2005. Statements that reference these tables will fail.

The following undocumented system tables are removed from SQL Server 2005:

spt_datatype_info
spt_datatype_info_ext
spt_fallback_db
spt_fallback_dev
spt_fallback_usg
spt_monitor
spt_provider_types
spt_server_info
spt_values
sysfulltextnotify
syslocks


Does this mean that BES will not run with SQL 2005?
Offline  
Old 02-02-2008, 02:27 PM   #2 (permalink)
BlackBerry Extraordinaire
 
gibson_hg's Avatar
 
Join Date: Dec 2007
Model: NA
PIN: 80081ES
Carrier: NA
Posts: 1,006
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

BES works fine with SQL 2005 and it uses it's own db, not a sys database. It does place entries in sysmessages but that table is not listed. It should work fine. Just back up the BES db anyways, that's all you need to backup for BES.
Offline  
Old 02-03-2008, 06:45 AM   #3 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,631
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Read this: How to move the BlackBerry Configuration Database to a new Microsoft SQL Server or instance

to move the configuration database

and read this: Move the BlackBerry MDS Services databases to a new SQL Server or server instance

if you're using an MDS Services database.

You can use SQL 2005 SP2 with the most current releases of BES 4.0 (SP7) and BES 4.1 (SP4) for Domino & Exchange ... I don't know GroupWise off hand.
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.