Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection



Reply
LinkBack Thread Tools Display Modes
KB03968 - How to increase or decrease the BlackBerry Configuration Database.....
 
  #1 (permalink)  
Old 01-15-2009, 04:11 AM
Si's Avatar
Si Si is offline
Proprietor
 
Join Date: Nov 2008
Location: London, UK
Posts: 1,046
Blog Entries: 6
Default KB03968 - How to increase or decrease the BlackBerry Configuration Database.....

KB03968 - How to increase or decrease the BlackBerry Configuration Database transaction log size

Environment


* BlackBerry® Enterprise Server software versions 3.6, 4.0 and 4.1
* SDR183866

Overview


Under certain conditions, it may be necessary to first decrease and then increase the size of the BlackBerry Configuration Database transaction log. For example, you may receive an error message stating that the BlackBerry Configuration Database transaction log is full. You can correct this by decreasing the transaction log size to free up disk space.

Decreasing the size of the BlackBerry Configuration Database transaction log


Note: Verify that the Installer and any other applications are closed when decreasing the size of the BlackBerry Configuration Database transaction log.

To decrease the BlackBerry Configuration Database transaction log size, complete the procedure appropriate to your database environment.

Microsoft® SQL Server® Desktop Engine (MSDE) 2000

1. Open a command prompt.
2. Type osql -E and press ENTER.
3. Type the following commands in the specified order and press ENTER after each line:

1> backup log with truncate_only

where is the name of the BlackBerry Configuration Database (for example, BESMgmt)

2> go

1> dbcc shrinkdatabase (, 1)

2> go

1> backup database to disk = "C:\backup.bak"

2> go

1> quit
4. Close the command prompt.

Microsoft® SQL Server® 2000

1. Open the SQL Enterprise Manager.
2. Go to Microsoft SQL Servers\SQL Server Group\\Databases.

where is the name of the Microsoft SQL Server instance hosting the BlackBerry Configuration Database.
3. Right-click the BlackBerry Configuration Database name (for example, BESMgmt), and then select All Tasks > Shrink Database.
4. Click OK.
5. Click OK again when the process is complete.
6. In the SQL Enterprise Manager, click Tools > SQL Query Analyzer.
7. In the SQL Query Analyzer, type the following:

backup log with truncate_only

where is the name of the BlackBerry Configuration Database (for example, BESMgmt).
8. Press F5 to process the query.
9. When the query is complete, close the SQL Query Analyzer.
10. Right-click the BlackBerry Configuration Database name in the SQL Enterprise Manager, and then select All Tasks > Backup Database.
11. Type a location for the backup files, and then click OK.
12. Click OK when the process is complete.

Increasing the size of the BlackBerry Configuration Database transaction log

The size of both the BlackBerry Configuration Database transaction log (LDF file) and the BlackBerry Configuration Database itself (MDF file) may be increased.

To increase the size of the BlackBerry Configuration Database in an MSDE 2000 or Microsoft SQL Server 2000 environment, complete the following steps:

1. Open a command prompt.
2. Type osql -E then press ENTER.
3. Type the following commands in the specified order and press ENTER after each command line:

1> exec sp_helpdb

where is the name of the BlackBerry Configuration Database (for example, BESMgmt).

Note: The BlackBerry Configuration Database name can be confirmed from the BlackBerry Server Configuration tool. This will display the logical file names used in the BlackBerry Configuration Database.

2> go

1> ALTER DATABASE BESMgmt MODIFY FILE(NAME='', SIZE=MB)

Note: Only include the logical file name. The entire path to the physical MDF or LDF file is not required.

2> go

1> quit
4. Close the command prompt.

ALTER DATABASE syntax examples

1> ALTER DATABASE BESMgmt MODIFY FILE(NAME=BESMgmt_log, SIZE=200MB)

or

1> ALTER DATABASE BESMgmt MODIFY FILE(NAME=BESMgmt_data, SIZE=150MB)

In the above syntax examples:

* BESMgmt_log is the logical file name for BESMgmt.ldf file in the Microsoft SQL Server database.
* BESMgmt_data is the logical file name for BESMgmt.mdf file in the Microsoft SQL Server database.

Increasing the size limitation for Microsoft SQL Server or MSDE

To increase the BlackBerry Configuration Database transaction log size, complete the procedure appropriate to your database environment.

Microsoft SQL Server

1. In the SQL Enterprise Manager, go to Microsoft SQL Servers\SQL Server Group\\Databases.
2. Right-click the BlackBerry Configuration Database name, and then click Properties.
3. On the Data Files and Transaction Log tabs, select the Automatically grow file check box.
4. Under the Maximum file size section, do one of the following:
* Select Unrestricted file growth to completely remove the size limitation.
* In the Restrict file growth (MB) field, type a new size limit.
5. Click Apply, and then click OK.

MSDE

1. Open a command prompt on the computer hosting the MSDE Server.
2. From the command prompt, type osql -E and press ENTER.
3. Type the following commands in the specified order and press ENTER after each line:

1> alter database modify file (name=, maxsize=UNLIMITED)

where is the logical file name (for example, BESMgmt) and is the logical file name for BESMgmt_data or BESMgmt_log

1> quit
4. Close the command prompt.

Microsoft SQL Server 2005

1. Open SQL Server Management Studio. If you are using Microsoft SQL Express, visit microsoft.com to obtain Microsoft SQL Server Management Studio.
2. Right-click the BlackBerry Configuration Database name, and then select Properties.
3. Select Files.
4. Increase the value in the Initial Size column to a value greater than the default settings.
5. Open the Autogrowth column for besmgmt.mdf.
6. Select the Enable Autogrowth check box.
7. Select the option for Unrestricted File Growth.
8. Open the Autogrowth column for besmgmt.ldf.
9. Select the Enable Autogrowth check box.
10. Select the option for Unrestricted File Growth.
11. Click OK to close the properties window.


Additional Information

For instructions on running Microsoft SQL Server maintenance jobs, see KB04426.
__________________
Si MCTS
Co-Owner
Port3101 - Your BES Connection

Don't forget, you can follow us on Twitter

The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 01-15-2009, 12:38 PM
knottyrope's Avatar
The knotty A D M I N
 
Join Date: Jan 2009
Location: Mass
Posts: 103
Default

Setting auto growth rate to 25 meg will actually reduce the amount of auto growths. Using the default value on a fairly loaded SQL server acutally creates problems.
__________________
------------------------------------------------------

Torch 9800 on BES 4.1.6 MR7, Exchange 2003, SQL 2005.
WES 2009-2010 Survivor
Reply With Quote
Reply

Thread Tools
Display Modes

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 On
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
KB18129 - Switching BlackBerry Configuration Database in BES 5.0 hdawg Featured BlackBerry KB Articles 1 03-27-2010 10:59 AM
KB10292 - How to back up and restore the BlackBerry Configuration Database Si Featured BlackBerry KB Articles 4 09-21-2009 09:10 PM
KB10669 - How to Move the BlackBerry Configuration Database for Domino hdawg Featured BlackBerry KB Articles 0 09-02-2009 09:51 PM
KB15678 - Unable to complete BlackBerry Configuration Database upgrade... Si Featured BlackBerry KB Articles 0 03-20-2009 04:13 AM
KB03968 - How to increase or decrease the BB Config Database transaction log size hdawg Featured BlackBerry KB Articles 0 12-18-2008 07:04 PM


All times are GMT -4. The time now is 01:22 PM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2019, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2