SQL Backup failed with exit code: 5240 SQL error code: 0 [SQLSTATE 42000] (Error 50000). The step failed. – SQB service did not acknowledge receipt of data (WAIT_TIMEOUT)

公司同事成日話..公司的 SQL Back up / Log Shipping 等的 SQL Job 成日都failed
好耐都無 success過了

最後都是忍不住去看看有什麼問題
SQL ServerLog File Viewer 上看到以下的 Log Summary
SQL Backup failed with exit code: 5240 SQL error code: 0 [SQLSTATE 42000] (Error 50000). The step failed.

Date		12/04/2016 14:00:00
Log		Job History (SQL Backup log shipping job for database ShareChiWaiDB created 28/03/2011 17:24:57)

Step ID		1
Server		SQL_01
Job Name		SQL Backup log shipping job for database ShareChiWaiDB created 28/03/2011 17:24:57
Step Name		execute master..sqlbackup
Duration		00:00:15
Sql Severity	16
Sql Message ID	50000
Operator Emailed	
Operator Net sent	
Operator Paged	
Retries Attempted	0

Message
Executed as user: SQL_01\Administrator. SQL Backup failed with exit code: 5240  SQL error code: 0 [SQLSTATE 42000] (Error 50000).  The step failed.

SQL Server Log File Viewer
因為知道這個SQL Job 是由RedGate建立的
所以便去了RedGateSoftware上看看
開啟這個Database node 時 發現以下的錯誤信息
SQB service did not acknowledge receipt of data (WAIT_TIMEOUT)
SQL service did not acknowledge receipt of data (WAIT_TIMEOUT)
做了一會research 之後發現解決方法十分簡單

只要去了那個Database Server的 “Administrative Tools” -> “Service” 上重新啟動 RedGate的”SQL Backup Agent“便可以了
Administrative Tools -> Services

Service” 上重新啟動 RedGate的”SQL Backup Agent
Restart RedGate -> SQL Backup Agent
Hope you find it useful

Leave a Reply