Error 1810

Severity

16

Message text

CREATE DATABASE failed because of incorrect size parameter(s). Total number of megabytes specified must be at least %d megabytes so that the Model Database can be copied to the new database.

Explanation

When a create database command is issued, Adaptive Server makes a copy of the model database, which contains the system tables needed by each database. Error 1810 occurs when you try to create a database of a size smaller than the size of the model database. The default size of model is 2 or 3MB, depending on the version of Adaptive Server Enterprise you are running.

Action

Make sure the size you plan to use in your create database command is at least as large as the model database (combine the data space size and the log space size).

To check the size of model, use this command:

1> sp_helpdb model 
2> go

Additional information

Refer to “model database” in the System Administration Guide: Volume 1 and “create database” in the Reference Manual: Commands for more information.

Versions in which this error is raised

All versions