Error 1820

Severity

20

Message text

This command adds %S_MSG space to disk ’%.*s’, which previously contained only %S_MSG.  You must specify WITH OVERRIDE to force this allocation.

Explanation

When a database is being extended or a new database created, Adaptive Server allocates space on the specified device (if no device is named, it uses the default device).

Error 1820 is raised when allocating space for the database converts the device from a dedicated device that stores only data or log into a mixed-use device that contains both data and log on the same segment.

The error may be detected:

Error 1820 is raised with the following states:

State

Meaning

1

Cannot allocate log space on a device dedicated to data. Device was named in the create database/alter database command.

2

Cannot allocate data space on a device dedicated to the log. Device was named in the create database/alter database command.

3

Cannot allocate log space on a device dedicated to data. Device was not explicitly specified. This state is also raised during HA proxy database creation (version 12.0 and later).

4

Cannot allocate data space on a device dedicated to the log. Device was not explicitly specified. This state is also raised during HA proxy database creation (version 12.0 and higher).

Action

Contact Sybase Technical Support with the information on hand that is listed in “Reporting errors”.

Additional information

For details about the management and recovery of the transaction log, see “Placing the Transaction Log on a Separate Device” in the System Administration Guide: Volume 2.

Versions in which this error is raised

Version 11.0.3 and later