Distribution box is down every day at 5am

Question

Distribution box is down every day at 5am

Chand00

SSCertifiable

Points: 6466
More actions
July 20, 2008 at 6:13 am

#123230

Hi,
One of the distribution box in our test environment running sql 2005 on windows 2003 was stopping everyday morning at 5.00am. Nothing is found in the event log or the sql log. But we can find the following entry in the sql agent log. I had run the profiler trace also but nothing is found. I suspect some process is trying to shutdown the server. How to
find out whether some process is doing this or some one.
SQLSERVERAGENT service stopping due to a stop request from a user or the OS
Thanks
Chandra Mohan
[font="Verdana"]Thanks
Chandra Mohan[/font]

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Animal Magic SSChampion Points: 13964 More actions · Answer 1

sometimes the culprit for this kind of thing can be backup software which runs a batch file to stop the sql services so it can copy the mdf and ldf files, normally by network admins that dont know about SQL.

Chand00 SSCertifiable Points: 6466 More actions · Answer 2

Hi,

Thanks for the reply. Can you tell me how do i find whether this is causing the services to stop or any other. Iam confused where to start to debug this issue.

Thanks

Chandra mohan N

[font="Verdana"]Thanks
Chandra Mohan[/font]

Animal Magic SSChampion Points: 13964 More actions · Answer 3

depending on what backup software your using you should be able to look if there is a batch command script attached to the pre and/or post backup run. Ask the guys who do your backups what time the backups run on the SQL box, they should know and you can rule it out straight away if its not around 5am.

It just seems likely to me that it is something like backup software, as not many people would get up at 5am each morning to shut down the services!

Just one quick question, do the services start up again or do you have to manually start them?

Chand00 SSCertifiable Points: 6466 More actions · Answer 4

Hi,

I had found out the root cause and resolved the issue. One our distribution box which is crucial to the business was getting shutdown everyday at morning 5.00am. We had run the profiler trace and found nothing. And after carefully studying the event log of the server we found that Windows Automatic update was scheduled to download and install updates everyday at morning 5.00am. And it had already downloaded a hotfix from windowsupdate website and trying to install everyday. As the microsoft sql server folder which contains the master and resource database was compressed it was unable to install and everyday when it tried to install it is failing. So I had removed the compression and it is working fine.

Thanks

Chandra Mohan N

[font="Verdana"]Thanks
Chandra Mohan[/font]