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



Reply
LinkBack Thread Tools Display Modes
KB14017 - Run Microsoft SQL Server maintenance using SQL Server 2005 Express
 
  #1 (permalink)  
Old 09-12-2009, 12:22 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default KB14017 - Run Microsoft SQL Server maintenance using SQL Server 2005 Express

KB14017 - Run Microsoft SQL Server maintenance using Microsoft SQL Server 2005 Express Edition


Environment

  • BlackBerry® Enterprise Server software versions 4.0 and 4.1



Overview

Unlike other versions of Microsoft® SQL Server®, Microsoft SQL Server 2005 Express Edition does not support the SQLServerAgent service. Therefore, maintenance jobs created by the BlackBerry Configuration Database installer are not executed automatically. This could affect the state of the Blackberry Configuration Database. For more information on performing BlackBerry Configuration Database maintenance, see KB04426.
To work around the SQLServerAgent service limitation, create a batch file that will use the Task Scheduler of Windows® to execute weekly maintenance jobs. The following is an example of the commands used in the batch file:
@ ECHO OFF

REM *****************************************************

REM * Batch File Used To Execute SQL Stored Procedures *

REM * To Maintain A BlackBerry Configuration Database *

REM *****************************************************

CLS

REM *****************************************************

REM * This Process Is Called By Windows Automated Task *

REM * Scheduler Nightly *

REM *****************************************************

CLS

call osql -E -d BESMgmt -Q "exec RemoveDeletedUsers 30"

call osql -E -d BESMgmt -Q "exec RemoveOldHistoryRows 60"

call osql -E -d BESMgmt -Q "exec RemoveOldWorkQueue 15"

CLS

REM *****************************************************

REM * End of Database Maintenance *

REM *****************************************************



Additional Information

BlackBerry Enterprise Server software version 4.1 Service Pack 5 (4.1.5) does not contain the RemoveDeletedUsers stored procedure, so this command will fail.
__________________
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
BES 5.0 on LCS 2005 Server 454SS Port 3101: The BES Admin Bar & Grill 1 09-20-2009 04:54 PM
KB04426 - How to run Microsoft SQL Server maintenance jobs for the BB Config DB hdawg Featured BlackBerry KB Articles 0 09-12-2009 12:23 PM
SQL Server 2005 SP3 ITJonny Port 3101: The BES Admin Bar & Grill 5 08-13-2009 10:16 PM
KB04586 - BlackBerry Enterprise Server support for Microsoft Exchange Server 2003 SP2 hdawg Featured BlackBerry KB Articles 0 06-25-2009 11:16 AM
KB11158 - What is the compatibility of BES versions 4.0 and 4.1 with SQL Server 2005 hdawg Featured BlackBerry KB Articles 1 04-14-2009 07:42 PM


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


 

SEO by vBSEO 3.3.2 PL2