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
