备份Transaction Log, 遇到了报错"there is no current database backup"

备份Transaction Log, 遇到了报错.

 

错误截图

 

错误信息:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Backup failed for Server 'SQL-SPS2013'.  (Microsoft.SqlServer.SmoExtended)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1917+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Backup+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

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

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1917+)&LinkId=20476

 

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

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

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

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

 

参考资料

=====================

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

http://blog.sqlauthority.com/2010/03/27/sql-server-fix-error-4214-backup-log-cannot-be-performed-because-there-is-no-current-database-backup/

Back Up a Transaction Log (SQL Server)

http://msdn.microsoft.com/en-us/library/ms179478.aspx