MAXSIZE cannot be less than SIZE for file '%ls'.

Error Message:
Msg 5103, Level 16, State 1, Line 1
MAXSIZE cannot be less than SIZE for file ‘%ls’.

Severity level:
16.

Description:
This error message appears when you try to create a database with a specified MAXSIZE less than the initial size of the database.

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 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.

Versions:
All versions of SQL Server.

Example(s):
USE master;
IF DB_ID (N’MyExample’) > 0
 DROP DATABASE MyExample;
GO
CREATE DATABASE MyExample
ON PRIMARY
( NAME = MyExample_Data,
    FILENAME = ‘E:MyExample_Data.mdf’,
    SIZE = 5,
    MAXSIZE = 4,
    FILEGROWTH = 15% )
LOG ON
( NAME = MyExample_Log,
    FILENAME = ‘E:MyExample_Log.ldf’,
    SIZE = 5MB,
    MAXSIZE = 25MB,
    FILEGROWTH = 5MB );
GO

Remarks:
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.

]]>

Leave a comment

Your email address will not be published.