SQL SERVER – FIX : ERROR : 4214 BACKUP LOG cannot be performed because there is no current database

Posted by pinaldave on SQL Authority See other posts from SQL Authority or by pinaldave
Published on Sat, 27 Mar 2010 01:30:15 +0000 Indexed on 2010/03/27 1:43 UTC
Read the original article Hit count: 850

I recently got following email from one of the reader.

Hi Pinal,

Even thought my database is in full recovery mode when I try to take log backup I am getting following error.

BACKUP LOG cannot be performed because there is no current database backup. (Microsoft.SqlServer.Smo)

How to fix it?

Thanks,
[name and email removed as requested]


Solution / Fix:

This error can happen when you have never taken full backup of your database and you try to attempt to take backup of the log only. Take full backup once and attempt to take log back up. If the name of your database is MyTestDB follow procedure as following.

BACKUP DATABASE [MyTestDB]
TO DISK = N'C:\MyTestDB.bak'
GO
BACKUP LOG [MyTestDB]
TO DISK = N'C:\MyTestDB.bak'
GO

Reference: Pinal Dave (http://blog.SQLAuthority.com)


Filed under: Pinal Dave, SQL, SQL Authority, SQL Backup and Restore, SQL Error Messages, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology Tagged: SQL Log

© SQL Authority or respective owner

Related posts about Pinal Dave

Related posts about sql