| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |
|---|---|---|---|---|---|---|---|---|---|---|
MSSQLSERVER_4214 |
MSSQLSERVER_ |
suresh-kandoth |
sureshka |
jopilov, mathoma |
08/20/2020 |
sql |
supportability |
reference |
|
[!INCLUDE SQL Server]
| 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 |
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.
Perform a full database backup before you try to backup the transaction log for a database.
For more information you can, see: Back Up and Restore of SQL Server Databases.