October 23, 2012 at 3:00 am
Hi Folks,
I have created maintainence plan to execute SQL Transaction log backups. the backup job is running for 20 to 30 minutes though it usually it takes only 1 to 2 minutes. The strangest part is when I check backup_start_date and backup_finish_date columns for backup duration, it gives me only 1 minute as usual.
But SQL agent job is running for 30 minutes. :crazy:
Any clues what can be the reason. Frequently SSIS SQL Agent jobs also have
The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Unable to complete login process due to delay in opening server connection
thanks.
Regards,
Raj
October 23, 2012 at 5:43 am
try this
open the SQL job that runs the package, went to the job step that runs the package, went to Advanced and set "Retry attempts" to 4 ( could be more if needed ), with Retry Interval set to 0 ( so it retries immediately and cant time out ).
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 23, 2012 at 5:44 am
also it might be because of short of resoures .
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply