Msg 5103, Level 16, State 1, Line 1
MAXSIZE cannot be less than SIZE for file ‘%ls’.
This error message appears when you try to create a database with a specified MAXSIZE less than the initial size of the database.
The T-SQL statement can be parsed, but causes the error at runtime.
Errors of the Severity Level 16 are generated by the user and can be fixed by the SQL Server user. The statement cannot be executed this way. The specified MAXSIZE must at least be equal to the initial size of the database.
All versions of SQL Server.
IF DB_ID (N’MyExample’) > 0
DROP DATABASE MyExample;
CREATE DATABASE MyExample
( NAME = MyExample_Data,
FILENAME = ‘E:MyExample_Data.mdf’,
SIZE = 5,
MAXSIZE = 4,
FILEGROWTH = 15% )
( NAME = MyExample_Log,
FILENAME = ‘E:MyExample_Log.ldf’,
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB );
In the above example we try to create a database with an initial size of 5 MB and a specified MAXSIZE of 4 MB. This raises the error.