Backup Job Hangs
1. SQL Server 2008 was unable to cancel the execution of the job. Manually restarting the red-gate backup service allowed SQL Server to abort the execution.
2. No backup attempt appears in the backup activity history.
3. No log backup file existed before process was cancelled. No log backup file existed after service restart.
4. No errors were reported.
5. The script being executed:
DECLARE @errorcode INT DECLARE @sqlerrorcode INT EXECUTE master..sqlbackup '-SQL "BACKUP LOGS [Billing] TO DISK = ''S:\Log Shipping\<SERVER>\<DATABASE>\<DATABASE>_<DATETIME YYYYmmddhhnnss>_<TYPE>.sqb'' WITH ERASEFILES = 7, MAILTO_ONERRORONLY = [url=''[email protected]]''[email protected][/url]'', CHECKSUM, DISKRETRYINTERVAL = 15, DISKRETRYCOUNT = 4, COPYTO = ''\\ServerName\s$\Log Shipping\<Server>\<Database>'', COMPRESSION = 4, THREADCOUNT = 7"', @errorcode OUT, @sqlerrorcode OUT; IF (@errorcode >= 500) OR (@sqlerrorcode <> 0) BEGIN RAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @errorcode, @sqlerrorcode) END