BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 06-17-2009, 08:46 PM   #1 (permalink)
New Member
 
Join Date: Jun 2009
Model: 9000
PIN: N/A
Carrier: Telstra
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default BES SQL Server Replacement and Upgrade Process

Please Login to Remove!

Currently, we run BlackBerry Manager version 4.1.3.18 on a Windows Server 2003 machine - which is connected to a separate SQL Server 2000 machine.

It is our intention to replace the SQL Server 2000 machine with a new Server running SQL Server 2005.

We will not be performing an upgrade to SQL Server 2005 on the existing Server - so I would assume this process would involve physically moving the database to the new Server, upgrading it to SQL Server 2005 and then pointing the client application to the upgraded database.

Can anyone please advise:

(i) What process we would follow to move the database from the old SQL Server (MSSQL2000) to the new one (MSSQL2005), and upgrade the database? Do you have documented instructions which details the process we must follow?
(ii) As we are deploying two replacement SQL Servers, we are also considering what options we would have available for Disaster Recovery.
(iii) And KB articles that may document this process and/or any known possible errors.


Any advice is much appreciated. Thank you!
Offline  
Old 06-17-2009, 08:49 PM   #2 (permalink)
BlackBerry God
 
penguin3107's Avatar
 
Join Date: Jan 2005
Model: iOS 5
Carrier: VZW
Posts: 11,701
Post Thanks: 1
Thanked 235 Times in 218 Posts
Default

This should get you started:
KB03112 - How to move the BESMgmt Database to a new SQL Server or instance - Port3101.org : Your BES Connection
__________________
BCSA
BES 5.0.3 MR4 :-: Exchange 2007 SP3 RU3
http://port3101.org
Offline  
Old 06-17-2009, 09:43 PM   #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

+1 for that. If you have further questions ... ask em ... but please read that first.
Offline  
Old 06-17-2009, 11:48 PM   #4 (permalink)
New Member
 
Join Date: Jun 2009
Model: 9000
PIN: N/A
Carrier: Telstra
Posts: 2
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you both for your assistance. The KB article looks good.

My main question is whether we can simply backup and restore the database (as per KB article) and it will be automatically upgrade to SQLServer2005 standard or whether there are other steps required aftewards to upgrade the database.
Offline  
Old 06-17-2009, 11:51 PM   #5 (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

the KB article indicates that a simple backup and restore is not all you need to do... If you just do a backup / restore it will not work.
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

Pilot 1600 advin systems EEPROM programmer
$136.0
Pilot 1600 advin systems EEPROM programmer pictureAllen Bradley 1785-ME32/A Rev. G01 32k EEPROM Memory Cartridge PLC5 1785ME32A
$159.99
Allen Bradley 1785-ME32/A Rev. G01 32k EEPROM Memory Cartridge PLC5 1785ME32A pictureSerial EEPROM 1024Kb (in 8 bit) 400Khz 24AA1025 24AA1025-I/P DIP8 x2 USA genui
$9.9
Serial EEPROM 1024Kb (in 8 bit) 400Khz 24AA1025 24AA1025-I/P DIP8  x2  USA genui pictureSerial EEPROM 1024Kb (in 8 bit) 400Khz 24AA1025 USA genuine
$3.9
Serial EEPROM 1024Kb (in 8 bit) 400Khz 24AA1025  USA genuine pictureALLEN BRADLEY AB 1747-M13 SLC-500 EEPROM MEMORY MODULE NEW
$85.0
ALLEN BRADLEY AB 1747-M13 SLC-500 EEPROM MEMORY MODULE NEW picture






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