Knowledge Base

SQL Backup "Warning 110" generated

Category: Troubleshooting & error messages
Date: 24 Mar 2011
Product: SQL Backup
SQL Backup "Warning 110" is generated when the SQL Backup Agent Service is unable to create or write to the SQL Backup log file location.

SQL Backup creates an unique text file for every backup or restore task and logs the actions taken during the backup or restore task to the text file generated.

1. The location of the SQL Backup Log files and ensure that you have sufficient free disk space. By default you will find the log files in the following folder on the machine where the SQL Backup Server Components are installed:

Windows 2003 server / Windows XP - C:\Documents and settings\All Users\Application Data\Red Gate\SQL Backup\Logs\<Instance Name>

Windows 2008 server / Windows Vista / Windows 7 - C:\ProgramData\Red Gate\SQL Backup\Log\<Instance Name>

2. If any changes have been made to the SQL Backup Agent Service, in particular account used to start the service has permissions to the above folder locations or the path specified in the SQL Backup GUI ->Server Options.