BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 11-15-2006, 12:06 PM   #1
Hatchy
Thumbs Must Hurt
 
Join Date: Oct 2005
Model: 8700
Carrier: Rogers
Posts: 56
Default MSDE or SQL?

Please Login to Remove!

Hi there. In an evironment of about 100 users on a Domino BES using a local MSDE database, what would be the main advantages of upgrading the MSDE database to a remove SQL server?

Any links somewhere outlining the advantages of SQL over MSDE? My boss wants to know why we should bother spending the money on SQL.

Thanks!
Offline  
Old 11-15-2006, 12:25 PM   #2
juwaack68
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,878
Default

We started out with MSDE (Exchange shop) and I moved to a remote SQL server earlier this year. My primary reasons for doing so were:
- Automatic backup of the SQL database (kinda handy in the case of a failure)
- Too many users on the box (we were at approx 225 users at the time, now at close to 400 on that BES)
- BES Management console was VERY slow to open. After moving to SQL it pops right open.
- Peace of mind (see first reason).
__________________
No longer a BES Admin, but it was fun while it lasted!
Offline  
Old 11-15-2006, 02:45 PM   #3
qc_metal
CrackBerry Addict
 
qc_metal's Avatar
 
Join Date: Mar 2005
Location: Rockford, IL
Model: 9530
OS: 4.7.x
Carrier: Verizon
Posts: 590
Default

Quote:
Originally Posted by juwaack68
We started out with MSDE (Exchange shop) and I moved to a remote SQL server earlier this year. My primary reasons for doing so were:
- Automatic backup of the SQL database (kinda handy in the case of a failure)
This one is easy to get around...just run a scheduled task that executes the OSQL backup command, and you can have it run weekly backups with no issue. Other command line parameters are available if you wish to perform incremental, etc.

Quote:
Originally Posted by juwaack68
- Too many users on the box (we were at approx 225 users at the time, now at close to 400 on that BES)
We were actually running 330 on MSDE with no issue. The database (this was Exchange) was sitting at around 220Mb or so, and this was including wireless backups.

There is a 2Gb limitation to MSDE (4 Gb to SQL Express), so there is something to think about. There is also a limitation to how many transactions you can process at one time, so this should really be the reason to go to SQL.

If you have SQL, I would definitely move to it, but I would perform an installation with the same version of BES, have it create the database and all the required tables, stored procedures, triggers, etc., then restore your database backup to it (pending you are moving forward or laterally in technology - - i.e. don't try to move from SQL Express 2005 to SQL 2000,
although not many folks I would imagine have tried this).

Rob
__________________
Provision, maintain, and report on users via web: the NEW BerryStats | FAQ
Offline  
Old 11-15-2006, 03:47 PM   #4
only1eagle
Thumbs Must Hurt
 
only1eagle's Avatar
 
Join Date: Nov 2005
Model: 7290
Carrier: T-mobile
Posts: 113
Default

how can you verify if your BES is running SQL or MSDE?>

And how can i find the location of the DB?

thanks in advance

Last edited by only1eagle; 11-15-2006 at 03:53 PM..
Offline  
Old 11-15-2006, 04:01 PM   #5
Hatchy
Thumbs Must Hurt
 
Join Date: Oct 2005
Model: 8700
Carrier: Rogers
Posts: 56
Default

Try this link:
http://www.blackberryforums.com/bes-...light=msde+sql
Offline  
Old 11-15-2006, 04:32 PM   #6
TChachra
Thumbs Must Hurt
 
TChachra's Avatar
 
Join Date: Mar 2005
Location: New York, NY
Model: 9000
Carrier: AT&T
Posts: 74
Default Small shop - We use SQL

We are a small shop with 35 users on our BES. However, we opted to use SQL for the peace of mind factor and the fact that we have veritas backup exec which runs a SQL agent to backup the DB without taking it down.

The speed is also unparalleled and requires that the BES box not be a heavy hitter...it can be a workstation if you want it to be.
Offline  
Old 11-15-2006, 10:30 PM   #7
gziz
Talking BlackBerry Encyclopedia
 
Join Date: Jun 2006
Model: 8700c
Carrier: cingular
Posts: 204
Default

blackberry recommends switching to SQL for mor ethen 500 users but i wouldnt have mor ethen 300 using MSDE
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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


New In Box Schneider TSXMRPC001M Memory Card Module picture

New In Box Schneider TSXMRPC001M Memory Card Module

$519.99



ENDOXPERT GASTROENTROLOGY MEMORY BASKET BRAND NEW picture

ENDOXPERT GASTROENTROLOGY MEMORY BASKET BRAND NEW

$118.36



Desktop Memory Case Tray Case for PC DDR DRAM RAM DIMM Modules - 2 fits 100 New picture

Desktop Memory Case Tray Case for PC DDR DRAM RAM DIMM Modules - 2 fits 100 New

$20.50



2 - RAM DRAM Tray-Container Box For Server PC Memory DIMM Modules - Fits 100 NEW picture

2 - RAM DRAM Tray-Container Box For Server PC Memory DIMM Modules - Fits 100 NEW

$21.90



Dental Endo NiTi Gold Taper Heat Activated /Rotary Files Engine Use 21mm/25mm picture

Dental Endo NiTi Gold Taper Heat Activated /Rotary Files Engine Use 21mm/25mm

$234.68



We R Makers The Cinch Book Binding Machine Round hole V 2 White Aqua 71050-9 picture

We R Makers The Cinch Book Binding Machine Round hole V 2 White Aqua 71050-9

$79.99







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