A message number uniquely identifies each error message and the error message
text describes the problem. The error message text often includes
placeholders for information (such as object names) to be inserted in the error
message when it is displayed. Unfortunately, the error message text does
not tell you how to solve or work around the problem. In this series of
Error Messages list, we will try to provide you with ways on how to overcome or
work around certain error messages.

Some error messages are self-explanatory and can easily be fixed, such as
"Invalid object name". Others are harder to fix or work around, especially
by those who are new to SQL Server. It is the intent of this page and
succeeding pages (to come) to assist you in addressing or working around
SQL Server error messages.

Error

Severity

Description

5001

16

User must be in the master database.

5002

16

Database '%.*ls' does not exist. Check
sysdatabases.

5004

16

To use ALTER DATABASE, the database must be
in a writable state in which a checkpoint can be executed.

5005

10

Extending database by %.2f MB on disk
'%.*ls'.

5006

16

Could not get exclusive use of %S_MSG
'%.*ls' to perform the requested operation.

5008

16

This ALTER DATABASE statement is not
supported.

5009

16

ALTER DATABASE failed. Some disk names
listed in the statement were not found. Check that the names exist and are
spelled correctly before rerunning the statement.

5010

16

Log file name cannot be generated from a
raw device. The log file name and path must be specified.

5011

14

User does not have permission to alter
database '%.*ls'.

5012

16

The name of the primary filegroup cannot be
changed.

5013

16

The master and model databases cannot have
files added to them. ALTER DATABASE was aborted.

5014

16

The %S_MSG '%.*ls' does not exist in
database '%.*ls'.

5015

16

ALTER DATABASE failed. The total size
specified must be 1 MB or greater.

5016

16

System databases master, model, and tempdb
cannot have their names changed.

5017

16

ALTER DATABASE failed. Database '%.*ls' was
not created with 'FOR LOAD' option.

No entry found for the primary log file in
sysfiles1. Could not rebuild the log.

5025

16

The file '%ls' already exists. It should be
renamed or deleted so that a new log file can be created.

5026

16

Could not create a new log file with file
'%.*ls'. See previous errors.

5027

16

System databases master, model, and tempdb
cannot have their logs rebuilt.

5028

16

The system could not activate enough of the
database to rebuild the log.

5029

10

Warning: The log for database '%.*ls' has
been rebuilt. Transactional consistency has been lost. DBCC CHECKDB should be
run to validate physical consistency. Database options will have to be reset,
and extra log files may need to be deleted.

5030

16

The database could not be exclusively
locked to perform the operation.

5031

16

Cannot remove the file '%.*ls' because it
is the only file in the DEFAULT filegroup.

5032

10

The file cannot be shrunk below page %ud
until the log is backed up because it contains bulk logged pages.

5035

16

Filegroup '%.*ls' already exists in this
database.

5036

16

MODIFY FILE failed. Specify logical name.

5037

16

MODIFY FILE failed. Do not specify physical
name.

5038

16

MODIFY FILE failed for file "%.*ls". At
least one property per file must be specified.

5039

16

MODIFY FILE failed. Specified size is less
than current size.

5040

16

MODIFY FILE failed. Size is greater than
MAXSIZE.

5041

16

MODIFY FILE failed. File '%.*ls' does not
exist.

5042

16

The %S_MSG '%.*ls' cannot be removed
because it is not empty.

5043

16

The %S_MSG '%.*ls' cannot be found in %ls.

5044

10

The %S_MSG '%.*ls' has been removed.

5045

16

The %S_MSG already has the '%ls' property
set.

5046

10

The %S_MSG property '%ls' has been set.

5047

16

Cannot change the READONLY property of the
PRIMARY filegroup.

5048

16

Cannot add, remove, or modify files in
filegroup '%.*ls'. The filegroup is read-only.

5049

16

Cannot extend file '%ls' using this syntax
as it was not created with DISK INIT. Use ALTER DATABASE MODIFY FILE.

5050

16

Cannot change the properties of empty
filegroup '%.*ls'. The filegroup must contain at least one file.

5051

16

Cannot have a filegroup with the name
'DEFAULT'.

5053

16

The maximum of %ld filegroups per database
has been exceeded.

5054

16

Could not cleanup worktable IAM chains to
allow shrink or remove file operation. Please try again when tempdb is idle.

5055

16

Cannot add, remove, or modify file '%.*ls'.
The file is read-only.

5056

16

Cannot add, remove, or modify a file in
filegroup '%.*ls' because the filegroup is offline.