BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 12-16-2006, 10:23 PM   #1
noname
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
Default My MSDE database full, need advise...

Please Login to Remove!

Hi all,

I have a small scale BES Domino installed just for my IT department guys, so decided to use MSDE to save cost. Anyway, it is just for our 50 odd IT guys.

Now I'm having problem adding user and get these errors:

[10226] (12/15 20:08:32):{0x1038} COM Error 0x45B680 in UpdateAgentId - Could not allocate space for object 'ServerConfigHistory' in database 'besmgmt' because the 'PRIMARY' filegroup is full. - IDispatch error #3092

[10224] (12/15 20:08:32):{0x1038} Database error in UpdateAgentId (err=0x80040E14, native err=1105) - Could not allocate space for object 'ServerConfigHistory' in database 'besmgmt' because the 'PRIMARY' filegroup is full.


First thing that came to my thought is the MSDE limit. My BESMgmt size is currently 102MB only, is it over the limit already?

Anyway, in an attempt to resolve this issue, I researched and found a RIM article KB-03968 "How To - Shrink or enlarge the BlackBerry Configuration Database transaction log". I tried to run the enlarge database part using the command ALTER DATABASE, but failed with an error:-

Msg 5041, Level 16, State 1, Server MY-BES-NAME, Line 1
MODIFY FILE failed. File 'BESMgmt' does not exist.

[BEGIN]
Enlarging the BlackBerry Configuration Database transaction log

To expand the BlackBerry Configuration Database transaction log when running MSDE 2000 or SQL Server 2000, complete the following steps:
  1. Open a command prompt.
  2. Type osql -E and press ENTER.
  3. Type the following commands in the specified order: 1> exec sp_helpdb <database_name>
    where <database_name> is the name of the BlackBerry Configuration Database (for example BESMgmt).
    Note: This will display the file names used in the BlackBerry Configuration Database.
    2> go
    1> ALTER DATABASE <database_name> MODIFY FILE (NAME = <database_name>, MAXSIZE=UNLIMITED)
    2> go
    1> quit
[END]

Folks, any ideas where went wrong? Thanks in advance.
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.

Last edited by noname; 12-17-2006 at 04:15 AM..
Offline  
Closed Thread



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


MSA 10042621 Altair 5X Sampling Probe Straight Air-Line 1' Color Black (E2) picture

MSA 10042621 Altair 5X Sampling Probe Straight Air-Line 1' Color Black (E2)

$295.00



🔅MSA altair 4X multi gas Meter Monitor detector, (O2,H2S,CO,LEL) & Charger picture

🔅MSA altair 4X multi gas Meter Monitor detector, (O2,H2S,CO,LEL) & Charger

$399.99



MSA 10042621 Altair 5X Sampling Probe Straight Air-Line 1' Color Black (E2) picture

MSA 10042621 Altair 5X Sampling Probe Straight Air-Line 1' Color Black (E2)

$325.00



MSA Gas Detector 10095774 Vehicle Car Auto Battery Charger CRADLE Altair 4x picture

MSA Gas Detector 10095774 Vehicle Car Auto Battery Charger CRADLE Altair 4x

$175.00



MSA Sensor Kit ALTAIR Pro ALTAIR 5X 10080222 picture

MSA Sensor Kit ALTAIR Pro ALTAIR 5X 10080222

$332.65



MSA 10106725 Sensor with Alarms 10/1700 ppm with Altair 4X/5X Multi-Gas Detector picture

MSA 10106725 Sensor with Alarms 10/1700 ppm with Altair 4X/5X Multi-Gas Detector

$199.00







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