May 10, 2007 at 9:26 am
We are running a SQL Server 2000 on a Windows 2000 server. This week the Windows shutdown twice and couldn't identify the problem and the log says unexpected shutdown. The server is on UPS. The SQL Server does heavy processing in the night (many jobs run simultaenously).
The timing of shutdown is onetime at the start of the jobs and another time at the end of the jobs.
My question is, can SQL Server cause Windows server to shutdowm?
Thanks,
Rushdi
May 10, 2007 at 1:53 pm
We've had some problems using a filebackup software (veritas) that was copying our .bak files at the moment that our backup job started to run.
Because of the folderlock the backupsoftware took, sqlserver (7.0) just crashed and the server rebooted !
The workaround we use nowadays is to xcopy the bak files in the last step of the backupjob to a safezone (if that fails is't not to bad) and have veritas only copy from the safezone to tape
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 10, 2007 at 2:03 pm
During the times the Windows crashed, no backups were done. So I don't think the backups were causing the issue for us.
May 11, 2007 at 10:36 am
Your UPS may have gone flaky. We had an issue that the battary of the UPS was no longer good, and every two weeks it would do an automated test, which promptly caused the servers to shutdown unexpectantly. I would plug an electric clock into the UPS, and next time your machine unexpectantly reboots check to see the the electric clock did not reboot (Blinking 12:00). Then you would know for sure it was your UPS, also if you have other servers plugged to the UPS it would be easy to tell.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply