Joined: 14 Jun 2006
Location: Red Gate Software
|Posted: Mon Mar 14, 2011 2:54 pm Post subject:
|Thank you for your post into the forum.
A support call has been created for you, the call reference number is F0045554.
There can be many causes to the problem you have described. Are there any entries in the SQL Server Error logs and VDI logs that indicate a possible cause of the error?
From your post, I see that you have already stopped and restarted the SQL Backup Agent Service. On the next occasion the problem occurs can you please running the following query from a new query window in SSMS / Query Analyzer:
|execute master..sqbutility 9997
This function will provide a debugging trace of the current execution process in the SQL Backup engine.
Executing sqbutility 9997 will return a NULL value and generate a file in the named directory for the corresponding SQL Backup Agent (eg by default, C:\Program files\Red Gate\SQL Backup\%instance%, called "SQBCoreService_bugreport.txt")
Please send the resulting debug file to firstname.lastname@example.org and include the above call reference number in the subject field on the e-mail.
Technical Support Engineer
Red Gate Software Ltd