BUG: Create Database Statement Does Not Allow Creation of Maximum Size Database File (268808)


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
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.
Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbBug kbpending KB268808
©2003 Microsoft Corporation. All rights reserved.