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)
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
No comments:
Post a Comment