Share via

Database Size Limitations in All Versions and Editions of SQL Server

  • Article

This article is related to this MSDN thread

According to this thread, the data file size limitation is not exposed through the query and most likely is hardcoded into the SQL Server assembly code.

We can find data file limitations in BOL and we can create our own table to hold this information based on SQL Server version and edition. The aforementioned thread provides the possible table:

CREATE TABLE  SQLServerVersions (
    VersionNumber VARCHAR(20) NOT NULL PRIMARY  KEY,
    SQLEdition VARCHAR(100) NOT NULL
    FileSizeData NUMERIC(19,0),
    FileSizeLog NUMERIC(19,0),
    DatabaseSize NUMERIC(19,0),
    ROW_ID INT  IDENTITY(1,1)
)
 
INSERT SQLServerVersions (
   '10.50', 'Standard Edition', 1099511627776, 1099511627776, 576443160117379072);
 
SELECT * FROM SQLServerVersions

BOL link http://msdn.microsoft.com/en-us/library/ms143432.aspx

See Also

Other Languages

This article is also available the following languages: