BACKUP failed to complete the command BACKUP DATABASE

是否使用tsql脚本通过sqlagent执行此备份作业?如果是这样,则需要在包含备份TSQL的作业步骤中指定输出文件。

In the Job Step on the left hand pane there should be General 和; Advanced . 点击 先进的 在标题下 Transact-SQL script (T-SQL) there is an output file box. Enter any valid filename here (it doesn't need to exist, it will create it on the fly).

更新:

Have you previously performed a FULL database backup for this database? 一 满 backup needs to exist before a DIFFERENTIAL backup can be performed.

最后,我发现了问题。这是由WindowsServer2008上的一个Windows备份引起的,该备份也在进行完全备份(幕后)。这导致SQL Server Diff备份找不到上一次完整备份。

We solved the problem by migration to Windows Server 2008 R2 .

To get detailed information about the problem: 1。Go to SQL Server Management Studio -> SQL Server Agent -> Jobs 2。Right click the name of the job which causes troubles and select "View History" 三。In Log File Viewer window select error end view detailed error message.

In my case the problem was in next error: 错误:“Web版本(64位)不支持压缩备份数据库。备份数据库正在异常终止。“