Google
Search WWW Search msexchangetips.blogspot.com

Monday, January 28, 2008

BlackBerry: DB upgrade failed. Error Executing an sql statement

Summary: When upgrading BES versions in this instance applying BES 4.1 Service Pack 4, you receive the following error "DB upgrade failed. Error Executing an sql statement" during database upgrade.


Resolution: In this instance; the cause was due to the MSDE database log file having exceeded it's default 50MB limit.

To verify the current size of the MSDE log file; go to C:\Program Files\Microsoft SQL Server\MSSQL\Data

Locate file BESMGMT.LDF. (Your database name may not be the same) Examine the file size to see if it has approached the 50MB limit.


To increase the limit:

1. Open a command prompt

2. OSQL -E

3. ALTER DATABASE BESMgmt MODIFY FILE(NAME=BESMgmt_log, SIZE=200MB)



Re-run the service pack or upgrade.



James Chong (MVP)
MCSE | M+, S+, MCTS, Security+
msexchangetips.blogspot.com

7 Comments:

Blogger Dan said...

I inherited our BES server, and I really know very little about it. I know even less about administering an MSDE SQL Server! But, I needed to upgrade our BES for E2k7 and I ran into this same issue.

Thank you so very much for posting your fix online. I had not ever heard of osql—I knew the syntax I needed, but w/o studio or something I wasn't sure how I was going to grow that log file.

Thank you, thank you, thank you!!

For others who may not know how to actually submit a query in osql, try:

OSQL -E -Q "ALTER DATABASE BESMgmt MODIFY FILE(NAME=BESMgmt_log, SIZE=200MB)"

How do you submit a query by the way? :-)

10:03 PM  
Anonymous Anonymous said...

I tried this and couldn't get it working, until I found out that you need to follow the command with 'GO' to actually perform the command! Could you update the post to reflect this, it mau save some other people some time!

Otherwise, thanks for the solution!

10:00 AM  
Anonymous Cialis Online said...

I get that error when I try to install the Service Pack 4 I don't know why that always happens to me.

9:23 AM  
Anonymous pharmacy said...

I really like this site, it's so important to know more about this topic, keep it up and of course every time I have time I'll love to check out again

2:00 PM  
Anonymous xlpharmacy said...

I've had a lot of issues and errors with this, thanks so much with this because now I know what was wrong with my applications.

10:35 AM  
Anonymous site said...

I saw a great deal of helpful information above!

1:28 PM  
Blogger Unknown said...

oakley sunglasses wholesale
saints jerseys
christian louboutin sale
oakley sunglasses
valentino shoes
oakley sunglasses
kate spade outlet
ralph lauren uk
ralph lauren outlet
coach factory outlet

11:14 PM  

Post a Comment

<< Home

xml:lang="en" lang="en"> MS Exchange Tips: BlackBerry: DB upgrade failed. Error Executing an sql statement