Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to:
SQL Server
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.