New in the Community? Get started here

Schneider Electric Exchange Community

Discuss and solve problems in energy management and automation. Join conversations and share insights on products and solutions. Co-innovate and collaborate with a global network of peers.

Register Now
Building Automation Knowledge Base
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
PSST, your community homepage is getting a new face - stay tuned and experience the change in few days

Continuum Database .MDF file is growing rapidly due to the file’s Autogrowth setting

Warning

Potential for Data Loss: The steps detailed in the resolution of this article may result in a loss of critical data if not performed properly. Before beginning these steps, make sure all important data is backed up in the event of data loss. If you are unsure or unfamiliar with any complex steps detailed in this article, please contact Product Support for assistance.

Issue

The Continuum database mdf file’s autogrowth setting is set to 12800 % causing the file to grow quickly. 

AutoGrowset too high.JPG 

When attempting to change the value in SQL Server Management Studio (SSMS) you receive the error below and the value cannot be changed.

Autogrowth error.JPG

Product Line

Andover Continuum.

Environment

  • Continuum Cyberstation
  • Microsoft SQL Server 2005 sp1

Cause

There is a known bug within SQL Server 2005 sp1 which causes the autogrowth setting for a database file to be set to 12800% with no user interaction.

Resolution

Since you cannot use the dropdown box to change the autogrowth function you will need to open a new query and execute the following two sql statements:

Alter Database ContinuumDB

Modify File (Name=’ContinuumDev’,Filegrowth = 10MB)

It may be necessary to change the Name of the database file that is being modified.  The autogrowth setting of 10 MB is the default for Continuum.

Note: Upgrading to SQL Server Service Pack2 or high should also resolve the issue.  Care should be taken to follow the Compatibility Matrix Update - Andover Continuum PA-00503  and Compatibility Matrix Update - Andover Continuum PA-00369   for service pack compatibility.

Tags (1)
Labels (1)
No ratings