Microsoft KB Archive/268808

= BUG: Create Database Statement Does Not Allow Creation of Maximum Size Database File =

Article ID: 268808

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q268808



BUG #: 58177(SQLBUG_70)

BUG #: 233598 (SHILOH)



SYMPTOMS
According to the Microsoft SQL Server Books Online, a single database file can have a maximum size of 32 TB (terrabytes). The CREATE DATABASE statement will not correctly handle a MAXSIZE value of 2,097,152 MB (megabytes) or larger. If the MAXSIZE parameter is specified in megabytes and the value is 2,097,152 MB or larger, the maxsize field overflows giving either a negative or otherwise incorrect value.



WORKAROUND
If you need to create a database larger than 2 TB, add additional files.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Keywords: kbbug kbpending KB268808

-

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

© Microsoft Corporation. All rights reserved.