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
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
posted by jamestechman at 9:06 AM
7 Comments:
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? :-)
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!
I get that error when I try to install the Service Pack 4 I don't know why that always happens to me.
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
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.
I saw a great deal of helpful information above!
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
Post a Comment
<< Home