Knowledgebase
Query Timeout Error in the log when backing up SQL DATABASE

 

"SQL Server Backup Failed. Database: NFC_HR, Reason: Error occured in Proc: ExecuteTSQL
Microsoft OLE DB Provider for SQL Server
Query timeout expiredCommand: BACKUP DATABASE "NFC_HR" TO DISK='F:\temp\SQL Server\NFC_HR.rbsql' WITH  NAME='Full Backup of NFC_HR'

Error occured in Proc: BackupDatabase
BackupDatabase
Database Backup operation failed"

Timeout error when doing SQL backup can be resolved by increasing plugin timeout value. Please follow the steps given below:

1. Close the RBS Endpoint. Stop rbclient.exe and rbackup.exe  processes via task manager.

2. Open the Registry editor and navigate to the following location.

if 32 bit server

HKEY_LOCAL_MACHINE\SOFTWARE\Quantum Tech, Inc.\Remote Backup\Plugins\SQL Server:


If 64 bit server

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432node\Quantum Tech, Inc.\Remote Backup\Plugins\SQL Server:


3. Create a new string value in the right pane.

"Timeout"  

Set it to a number greater than 6000 (the default value is 6000)


(0 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
Online Backup Software by Remote Backup Systems fusion