SQL SERVER恢复数据报错BACKUP LOG cannot be performed because there is no current database backup.

ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: BACKUP LOG cannot be performed because there is no current database backup. (Microsoft.SqlServer.Smo)

这个错误的原因是从来就没有为该数据库做过full backup, 却仅想要备份log. 解决方案就是先做一个full backup, 然后再备份log就可以了

假设我们的database的名字是db_test, 可以使用的脚本如下:

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

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