Microsoft KB Archive/224160

= FIX: Create DB Wizard Incorrectly Sets Transaction Log File Growth =

Article ID: 224160

Article Last Modified on 3/14/2006

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q224160



BUG #: 53547 (SQLBUG_70)



SYMPTOMS
When you use the Create Database Wizard in the SQL Server Enterprise Manager to create a new database, it sets the transaction log file growth size restriction to the database file growth restriction size, rather than the size specified for the log.



WORKAROUND
You can create a database outside of the Create Database Wizard as follows:
 * 1) Right-click the Databases folder in the Enterprise Manager and choose New Database.
 * 2) Click the General tab and then specify the database file information including the Restrict Filegrowth size.
 * 3) Click the Transaction Log tab and specify the transaction log file information including the Restrict Filegrowth size.
 * 4) Choose OK to create the database.

RESULT: The correct filegrowth restriction size for the transaction log will be used to create the database.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

232570INF: How to Obtain Service Pack 1 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0

For more information, contact your primary support provider.

Keywords: kbbug kbfix KB224160

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.