What is the maximum size of a SQL Server database?

What is the maximum database size in SQL Server 2019?

Maximum Database Size The major limitation in the SQL Express database is that the storage limit which is 10 GB. However, it is important to note that this limitation is on the data file and the log file is excluded from this limitation. This means log files can be in any size.

What is database size in SQL Server?

If you need to check a single database, you can quickly find the SQL Server database sizein SQL Server Management Studio (SSMS): Right-click the database and then click Reports -> Standard Reports -> Disk Usage. Alternatively, you can use stored procedures like exec sp_spaceused to get database size.

What is the maximum size of a database?

The maximum size of a database file is 4294967294 pages. At the maximum page size of 65536 bytes, this translates into a maximum database size of approximately 1.4e+14 bytes (281 terabytes, or 256 tebibytes, or 281474 gigabytes or 256,000 gibibytes).

What is the default size of an SQL Server database?

When you create a database, the default size is 8MB. The autogrowth setting is 64MB at a time with unlimited growth (SQL Server 2016). By the way, the initial size and autogrowth settings are not the same between SQL Server versions. You can see this in the SQL Server 2016 and SQL Server 2008 R2 screenshots below.