December 3, 2003 at 1:49 pm
I am backing up a log file on a db every hour. At least one time a day the job hangs, it was created with maintenance plan. The rest of the time it is ok. I get no error other than sqlmaint failed. In the server log says it completes ok. The job history log and job maintenance log have no entires until I kill the process, and then they say it failed. The Agent log has just info message that says the job started? I have deleted and completely recreated plan several times. I have changed the time it runs since another log backup was running starting at the same time. I have looked to the Knowledge base with no success. Where else should I look or what do you suggest I do to troubleshoot. Thanks
December 3, 2003 at 2:05 pm
Did you check if the agent process was locked by any other process when it seems to hang?
December 3, 2003 at 2:13 pm
quote:
Did you check if the agent process was locked by any other process when it seems to hang?The actual process running the log backup was not waiting for a lock or was not blocked. There was nothing else running through the agent at that time. Other jobs had run while this one was hung and they completed successfully.
December 3, 2003 at 8:27 pm
Hi there
This is a tricky one indeed, I would try profiling the db and see if you can trace out the steps being taken, also, did you notice any correlation between lockup vs log file size? or any other job that runs before it that is specific around the times of the lockup? what is the owner of the job btw?
A final check - any other SW running, virus checkers etc locking files?
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
December 8, 2003 at 7:16 am
Delete this maintenance plan .. and then make backuping up the log in a new maintenance plan .. and see if the error is still exist or not ..
also try to install all of the SP of SQl Server .. and SP of MDAC on server machine
Alamir Mohamed
Alamir Mohamed
Alamir_mohamed@yahoo.com
December 9, 2003 at 1:24 am
Does your maintenance plan include a FULL database backup as well?.
A full backup will block the transaction log backup until it completes
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply