BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 02-02-2008, 12:50 PM   #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, 03: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, 07:45 AM   #3 (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

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

FISHER 1N10126G012 POTENTIOMETER * NEW IN BOX *
$15.0
FISHER 1N10126G012 POTENTIOMETER * NEW IN BOX * pictureUseful 75pcs 15 Values 3296W 50 ohm ~ 2M ohm Potentiometer Assortment Kit F1J3
$12.25
Useful 75pcs 15 Values 3296W 50 ohm ~ 2M ohm Potentiometer Assortment Kit F1J3 picture100K Ohm Trimpot Breadboard Trim Potentiometer P104 With Knob For Arduino (Pa...
$12.76
100K Ohm Trimpot Breadboard Trim Potentiometer P104 With Knob For Arduino (Pa... picture1Set 3296W Adjustable Potentiometer Precision 100R-2M Adjust Resistor 12 Values
$7.52
1Set 3296W Adjustable Potentiometer Precision 100R-2M Adjust Resistor 12 Values picture






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