MSSQLSERVER_4214

Applies to: yesSQL Server (all supported versions)

Details

Attribute Value
Product Name SQL Server
Event ID 4214
Event Source MSSQLSERVER
Component SQLEngine
Symbolic Name DMPX_NODBBACKUP
Message Text BACKUP LOG cannot be performed because there is no current database backup

Explanation

The error is raised when you attempt a transaction log backup before doing a full backup of a database. Before you try to back up the transaction log for a database you must perform a full database backup. Additionally, you receive the following message in the error log:

<Datetime> Backup Error: 3041, Severity: 16, State: 1.
<Datetime> Backup BACKUP failed to complete the command BACKUP LOG <db_name>. Check the backup application log for detailed messages.

User action

Perform a full database backup before you try to backup the transaction log for a database.

More information

For more information you can, see: Back Up and Restore of SQL Server Databases.