Red Gate forums :: View topic - SQL Backup Hangs
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

SQL Backup Hangs

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
kathystroh



Joined: 07 May 2014
Posts: 1
Location: Wilmington, DE

PostPosted: Wed May 07, 2014 2:15 pm    Post subject: SQL Backup Hangs Reply with quote

We have several SQL Backup jobs, to back up our databases both full and differentials, as well as transaction logs. Several times, the jobs have hung. When this happens, the SQL Backup GUI does not show the job active, but SQL Agent does and there is a SQL process. The only way I have found to end the job is to restart the SQL Agent service. The only way I have found to end the process is to restart the SQL Service. Has anyone seen this issue before? Any ideas on how to fix it?
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2306

PostPosted: Thu May 08, 2014 1:00 am    Post subject: Reply with quote

When SQL Backup encounters a critical error, it generates a stack trace of events leading up to the error. This stack trace is then stored in a file named SQBCoreService_<instance name>_bugreport.txt, and is located in 'C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\' on Windows 2003 and older, and 'C:\ProgramData\Red Gate\SQL Backup\Log\' on Windows Vista and newer.

Could you please check if that file exists on your system? If it does, could you please send it to me (peter.yeoh@red-gate.com)? If the file does not exist, it may be because the SQL Backup Agent service startup account does not have rights to create the file in that folder. You can test this by manually creating the stack trace file by running the following command from Query Analyzer/Management Studio when connected to the SQL Server instance:

EXEC master..sqbutility 9997

If the file is not created, try granting read/write permissions on the abovementioned folder to the SQL Backup Agent service startup account.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group