The file size, max size cannot be greater than 2147483647 in units of a page size. The file growth cannot be greater than 2147483647 in units of both page size and percentage.

Error Message:
Msg 1842, Level 16, State 1, Line 2
The file size, max size cannot be greater than 2147483647 in units of a page size. The file growth cannot be greater than 2147483647 in units of both page size and percentage.

Severity level:
16.

Description:
This error message appears when you try to create a new database file with more than 2147483647 pages or try to extend an existing one beyond this number.

Consequences:
The T-SQL statement can be parsed, but causes the error at runtime.

Resolution:
Errors of the Severity Level 16 are generated by the user and are corrigible by the user. The statement cannot be executed this way. You cannot create or extend a database file beyond 2147483647 pages.

Versions:
All versions of SQL Server.

Example(s):
USE Pubs
ALTER DATABASE Pubs
ADD FILE
(
 NAME = Pubs1,
 FILENAME = ‘Z:pubs1.ldf’,
 SIZE = 2147483647MB,
 MAXSIZE = 2147483647MB,
 FILEGROWTH = 5MB
)

Remarks:
In the above example we try to create a new database file with 2147483647 MB. This raises the error.