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



Reply
LinkBack Thread Tools Display Modes
KB11209 - The SQL transaction log file for the BESMgmt database on SQL is full
 
  #1 (permalink)  
Old 08-23-2009, 08:53 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default KB11209 - The SQL transaction log file for the BESMgmt database on SQL is full

KB11209 - The SQL transaction log file for the BESMgmt database on the Microsoft SQL Server is full


Environment

  • BlackBerry® Enterprise Server software version 4.0.x and 4.1.x
  • Microsoft® SQL Server®



Overview

The Structured Query Language (SQL) transaction log file for the BESMgmt database on the Microsoft SQL Server is full. The log grows quickly and reaches over 1 GB.



Cause

The recovery model for the Microsoft SQL Server database is set to Full.



Resolution

Change the Microsoft SQL Server recovery model to Simple.
  1. In the Enterprise Manager for the Microsoft SQL Server, right-click on the BESMgmt database and select Properties.
  2. Click the Options tab.
  3. Under Recovery, change the model to Simple.
  4. Stop and start the Microsoft SQL Server.
Note: You may need to stop and start the BlackBerry Dispatcher service on the BlackBerry Enterprise Server to reconnect.
Important: Restarting certain BlackBerry Enterprise Server services will delay email message delivery to BlackBerry devices. For more information, see KB04789.
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
Sponsored Links
Reply

Bookmarks

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
Transaction Logs Getting Full Marcus Port 3101: The BES Admin Bar & Grill 0 09-13-2011 07:35 AM
Importing an SQL Besmgmt database over the top arthurlandry Port 3101: The BES Admin Bar & Grill 0 04-27-2010 03:58 PM
BESMgmt SQL Database Mirroring mahoward Port 3101: The BES Admin Bar & Grill 7 03-05-2010 06:29 PM
KB03543 - Unable to open BESMgmt database hdawg Featured BlackBerry KB Articles 0 09-24-2009 04:24 PM
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 07:06 AM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2018, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2