October 14, 2011 at 3:34 pm
I'm trying to use Service-Broker internal activation to run multi-threaded backups, ie. launch backups for several databases in parallel, starting from a single process that is looping through a list of databases in my instance.
However, my internal-activation stored procedure in the target queue is failing with this error:
"ErrorNumber - 3013 : ErrorMessage - BACKUP DATABASE is terminating abnormally."
The sproc is executing a simple backup command.
The target queue is configured as follows:
ALTER QUEUE Backups_TargetQueue
WITH ACTIVATION
( STATUS = ON,
PROCEDURE_NAME = Backup_internalActivationTarget,
MAX_QUEUE_READERS = 4,
EXECUTE AS SELF
);
GO
Has anyone else experienced this problem? I have a feeling it has to do with the security context of the Service-Broker process, but I can't think of what I need to change.
I have omitted a lot of details here to make this post easier to digest. Please let me know if any more details are needed.
Thanks for any feedback.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 14, 2011 at 8:04 pm
google says http://support.microsoft.com/kb/290787
October 15, 2011 at 5:09 am
SpringTownDBA (10/14/2011)
google says http://support.microsoft.com/kb/290787
Thanks, but this link does not apply to sql 2008 (whick I'm on). Besides, the exact same backup command works fine on its own (outside the internal-activation sproc).
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 16, 2011 at 11:22 am
Can you give us the actual error message(s) you are getting?
October 17, 2011 at 9:55 am
Lynn Pettis (10/16/2011)
Can you give us the actual error message(s) you are getting?
Mentioned in my initial posting:
"ErrorNumber - 3013 : ErrorMessage - BACKUP DATABASE is terminating abnormally."
I capture this error in a TRY/CATCH block in the activation sproc and record it in a table.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
October 17, 2011 at 10:23 am
Did you check the SQL Serror log as well? There may be more information in other logs that would help identify the problem.
October 17, 2011 at 11:20 am
Lynn Pettis (10/17/2011)
Did you check the SQL Serror log as well? There may be more information in other logs that would help identify the problem.
There are no corresponding errors or related messages in the SQL ERRORLOG around the time of the error.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply