BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 06-25-2006, 05:37 PM   #1 (permalink)
iPhone Convert
 
juwaack68's Avatar
 
Join Date: Oct 2005
Location: Tulip City - MI
Model: iP5
OS: 6.0.2
PIN: to beans
Carrier: I'm not
Posts: 13,875
Post Thanks: 3
Thanked 72 Times in 55 Posts
Default Have moved DB from MSDE200 to SQL2000

Please Login to Remove!

We moved our BES database from the MSDE2000 to a dedicated SQL2000 server today and everything is working fine. Main reason for moving to SQL was the number of users (340 and counting) and so the database will get backed up automatically (rather than my remembering to do it manually...which doesn't work so well).

First - what are the other advantages I should see by doing this? This might sound like a lame question, but my reasons for moving are above, and I just am curious what else I should notice.

Also, there is a BB KB article about manually increasing the mail agent limitation after moving to SQL. Is this something I SHOULD do, or just a recommendation (this BES is connected to 2 local Exchange 2003 servers).
__________________
No longer a BES Admin, but it was fun while it lasted!
Offline  
Old 06-25-2006, 05:58 PM   #2 (permalink)
Thumbs Must Hurt
 
djbeenie's Avatar
 
Join Date: Feb 2005
Location: Jefferson Ga.
Model: 8900
PIN: 20F7C0E8
Carrier: TMO
Posts: 151
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I just moved my database as well to SQL. I get a little bit of a delay now with a bunch of CDO errors in my event log. I had to run out of town for an emergency, but returning tommorow to trouble shoot some more on the issue. Anyone have any tippers? Don't mean to barge into your thread, I am just courious of other problems.
__________________
Pin: 20F7C0E8
TMO 8900 - Exchange 2007 SP1 - BES 4.1.6
Offline  
Old 06-26-2006, 08:19 AM   #3 (permalink)
iPhone Convert
 
juwaack68's Avatar
 
Join Date: Oct 2005
Location: Tulip City - MI
Model: iP5
OS: 6.0.2
PIN: to beans
Carrier: I'm not
Posts: 13,875
Post Thanks: 3
Thanked 72 Times in 55 Posts
Default

I have noticed that some things run faster than they have before - like the BES Management console and the Handheld Config tool open a lot faster. Also, anything using MDS on my handheld seems to run a little faster, and email seems to be faster, too.
__________________
No longer a BES Admin, but it was fun while it lasted!
Offline  
Old 09-18-2006, 10:24 PM   #4 (permalink)
New Member
 
Join Date: Jun 2005
Location: India
Model: 7100g
Carrier: Airtel
Posts: 9
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Can I have the steps to perform the move database from MSDE to SQL ?
Offline  
Old 10-27-2006, 09:08 AM   #5 (permalink)
New Member
 
Join Date: Oct 2006
Model: 7100t
Posts: 1
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default MSDE2000 to SQL 2000

Can you please post or send the instructions for this procedure? We're about to do this and your help would greatly be appreciated.

Thanks
Offline  
Old 10-27-2006, 01:47 PM   #6 (permalink)
iPhone Convert
 
juwaack68's Avatar
 
Join Date: Oct 2005
Location: Tulip City - MI
Model: iP5
OS: 6.0.2
PIN: to beans
Carrier: I'm not
Posts: 13,875
Post Thanks: 3
Thanked 72 Times in 55 Posts
Default

I following the instructions found in RIM's knowledgebase article KB03112.

I know I ran into a small issue, but don't remember what it was. Fortunately my company has T-Support from RIM, so I was able to get the issue resolved very quickly.
__________________
No longer a BES Admin, but it was fun while it lasted!
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.