Long running backup job
In searching the forums I did find this post: http://red-gate.com/messageboard/viewto ... light=hung
I took the steps and have reduced the amount of data in the backup tables in MSDB; however, that has not reduced the time. We issued an UPDATE STATS and DBCC DBREINDEX on the tables as well to no avail.
SQB shows that the actual backup is only taking 1-5 seconds, what could possibly be taking so long with the actual job?
I did a DBCC INPUTBUFFER on the SPID and this is what is being run:
DECLARE @exitcode int DECLARE @sqlerrorcode int exec master..sqlbackup N'-SQL "BACKUP LOGS [XXXX] TO DISK = ''\\ctac\service\sqlbackup\RedGate\XXXX\XXXXX\<AUTO>'' WITH NAME = ''<AUTO>'', DESCRIPTION = ''<AUTO>'', NO_TRUNCATE, ERASEFILES = 1, COM
Any help with this would be greatly appreciated!