Database Size Limitations in All Versions and Editions of SQL Server

Database Size Limitations in All Versions and Editions of SQL Server

This article is a stub and it 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


Leave a Comment
  • Please add 4 and 2 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Naomi  N edited Revision 2. Comment: Changed title

  • Naomi  N edited Original. Comment: Edit link

Page 1 of 1 (2 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Naomi  N edited Original. Comment: Edit link

  • Naomi  N edited Revision 2. Comment: Changed title

Page 1 of 1 (2 items)