BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 11-17-2006, 07:56 AM   #1 (permalink)
Knows Where the Search Button Is
 
Join Date: Jul 2005
Model: 8800
Carrier: USAF
Posts: 33
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Bes Sql

Please Login to Remove!

I have access to SQL 2005 Standard, and 2000 Standard. Is 2005 compatible with BES 4.1 SP2?

Adams
Offline  
Old 11-17-2006, 10:03 AM   #2 (permalink)
Thumbs Must Hurt
 
Join Date: Feb 2006
Location: Canada
Model: 7250
Carrier: Telus
Posts: 131
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by DAdams91982
I have access to SQL 2005 Standard, and 2000 Standard. Is 2005 compatible with BES 4.1 SP2?

Adams
No.. You must use SQL 2000.

Andrew
Offline  
Old 12-22-2006, 03:53 AM   #3 (permalink)
Knows Where the Search Button Is
 
Join Date: Jul 2005
Model: 8800
Carrier: USAF
Posts: 33
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

okay, I have found out, I can run on SQL 2005, and this is after the fact of installing 2000. My question now, is how painless is upgrading 2000 to 2005 on my live SQL server for BES. Is it reliable? As in can I count on it to come back and everything work perfectly after upgrade? Also, will I need to do anything on the BES portions of the site. Im running 4.1 SP2 HF1

Also thanks to everyone that has helped me in the past.. .this forums has saved my ass countless times.

Thanks all, and a Merry Christmas to all.

SSgt Adams
Offline  
Old 12-22-2006, 12:32 PM   #4 (permalink)
Thumbs Must Hurt
 
Join Date: Aug 2006
Model: 8100
Carrier: T-Mobile
Posts: 111
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I've been running 4.1.2 on SQL2005 for months now, its great, and supported ;)
__________________
"I take off my robe and wizard hat...."
Offline  
Old 12-23-2006, 06:52 PM   #5 (permalink)
Knows Where the Search Button Is
 
Join Date: Jul 2005
Model: 8800
Carrier: USAF
Posts: 33
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by Logvin
I've been running 4.1.2 on SQL2005 for months now, its great, and supported ;)
Any idea how tough, and realiable it is to upgrade from 2000, to 2005?

Adams
Offline  
Old 12-23-2006, 07:30 PM   #6 (permalink)
Knows Where the Search Button Is
 
Join Date: Jul 2005
Model: 8800
Carrier: USAF
Posts: 33
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Okay.. just realized my SQL is 2000 SP 3a. Now, I want to at least get this up to SP4... how safe is applying the service pack to my only live server? Obviously i will back up the DB and everything, but will it jack up anything with BES? As in when I apply it, will I have to go back to BES and do anything to that?

Thanks,
SSgt Adams
Offline  
Old 12-24-2006, 07:19 PM   #7 (permalink)
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Post Thanks: 6
Thanked 9 Times in 9 Posts
Default

I would stay at sql 2000 sp3 unless there is a need to go sp4. Check with Microsoft what are the patches for the new pack first. If your bes is running fine and there is no complaints as far as sql server is concern, then I would not upgrade.
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Offline  
Old 12-26-2006, 12:37 PM   #8 (permalink)
Knows Where the Search Button Is
 
Join Date: Jul 2005
Model: 8800
Carrier: USAF
Posts: 33
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by noname
I would stay at sql 2000 sp3 unless there is a need to go sp4. Check with Microsoft what are the patches for the new pack first. If your bes is running fine and there is no complaints as far as sql server is concern, then I would not upgrade.
Well I was reading some disaster recovery stuff for blackberry. And I want to setup replecation to a backup SQL server, in case the initial one goes down. After reading up about the upgrade... SP4 is alot more functional in this means. Hence the reason I wish to upgrade.

Adams
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

Vintage Fruit Wine Cider Press Juice Maker Grapes Crusher Harvest Apple Antique
$142.98
Vintage Fruit Wine Cider Press Juice Maker Grapes Crusher Harvest Apple Antique pictureVTG APPLE COMPUTER MEAD ZIPPERED ORGANIZER CASE
$19.99
VTG APPLE COMPUTER MEAD ZIPPERED ORGANIZER CASE  pictureVintage EDM 926 ELECTROHOME monitor Apple II
$199.0
Vintage  EDM 926 ELECTROHOME monitor Apple II   picture Vintage OEM Apple Design Powered Speakers M2497 USED WORKING
$39.99
 Vintage OEM Apple Design Powered Speakers M2497 USED WORKING pictureVintage Letterpress Print Type Ornament "An Apple A Day Bugs The A.M.A." Adcut
$9.5
Vintage Letterpress Print Type Ornament






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