January 12, 2009 at 4:28 am
Hi,
We are trying to execute one sql job through SQL Server agent. This job takes backup of our main production database.Earlier it was running fine, but from the last 3-4 days it's getting failed , giving error:
"Unspecified error occured on SQL server.Connection may have been terminated by the server.[SQLSTATE HY000][Error 0].The step failed.
Any help would be appreciated.
Thanks in advance
January 12, 2009 at 5:25 am
Have you stopped and started SQL Agent service? That would be my first try. Second would be to copy the code from the step and make sure that it runs independently of the job.
It would also be worthwhile to check the error log to see what you have in there for the time that the job runs. Post back with more details as you get them. Thanks.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply