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 BB Config Database transaction log size
 
  #1 (permalink)  
Old 12-18-2008, 07:04 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default KB03968 - How to increase or decrease the BB Config Database transaction log size

KB03968 - How to increase or decrease the BB Config 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 <database_name> 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, you can obtain Microsoft SQL Server Management Studio Express.
  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.
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
Sponsored Links
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
Max. email message size / attachment-size? ebb31 Port 3101: The BES Admin Bar & Grill 1 06-18-2010 08:04 PM
KB11209 - The SQL transaction log file for the BESMgmt database on SQL is full hdawg Featured BlackBerry KB Articles 0 08-23-2009 08:53 PM
KB17154 - Increase in memory usage on BES and increase in connections from BES ... hdawg Featured BlackBerry KB Articles 0 06-23-2009 11:21 PM
KB13935 - Export BlackBerry smartphone user information stored in the Config Database hdawg Featured BlackBerry KB Articles 0 04-14-2009 07:23 PM
KB03968 - How to increase or decrease the BlackBerry Configuration Database..... Si Featured BlackBerry KB Articles 1 01-15-2009 12:38 PM


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


 

SEO by vBSEO 3.3.2 PL2