Error 3023

Severity Level 16

Message Text

Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as CREATE FILE) operations on a database must be serialized. Reissue the statement after the current backup, CHECKALLOC, or file manipulation operation is completed.

Explanation

These operations may not be performed at the same time as a backup operation:

• File management operations such as the ALTER DATABASE statement with either the ADD FILE or REMOVE FILE clauses; INSERT, UPDATE, or DELETE statements.
• Shrink database or shrink file.
• CREATE INDEX.
• Nonlogged operations such as bulk load, SELECT INTO, WRITETEXT, and UPDATETEXT. The database option select into/bulkcopy must be enabled for these operations to be nonlogged.

If a backup is started when one of these operations is in progress, the backup ends. If a backup is running and one of these operations is attempted, the operation fails. For more information, see Remarks in BACKUP.

Action

Reissue the operation after the conflicting operation has completed.

See Also