Technical FAQs

Ask a Question

Database Manager fails during database upgrade with "Could not upgrade MSDE Database: The transaction log for database 'ION_Data' is full due to 'ACTIVE_TRANSACTION'."

Issue
Customer is unable to upgrade a database using the Database Manager and received the following error:

"Could not upgrade MSDE Database: The transaction log for database 'ION_Data' is full due to 'ACTIVE_TRANSACTION'."

Product Line
Power Monitoring Expert 8.x

Environment
Database Manager
SQL Server Management Studio

Cause
The Autogrowth parameters are restricting the database from growing during the upgrade process.

Resolution
Verify the attached database has Autogrowth set to Unlimited.
 
  1. Open SQL Server Management Studio
  2. Connect to Server Instance
  3. In the Object Explorer, expand Databases
  4. Right-click on the database in question and select Properties
 
  1. Select the Files page
  2. Set the Primary filegroup to an Autogrowth/Maxsize of "By 10 percent, Unlimited"
Was this helpful?
What can we do to improve the information ?