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: 1117
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
|SQL Log
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
