Friday, February 10, 2012

Backup Followed by Crash

Hi. I have a SQL Server 2000 server that runs backups
every night on a handful of not very active databases.
Recently, the server has crashed or hung each time,
following successful backup of all but the last database.
No error message, no warning. The system log shows a
successful completion of the next-to-last backup. About
six seconds later (usually) there is a system time stamp
in the security log. Then the system just checks out,
sometimes powered down, sometimes hung but still powered
on. I have to manually reboot the system.
Any suggestions on how to track down the problem?
Thanks!
Nora Miller
Portland OR
NMiller,
What's in your
* SQL Server error log
* Windows Appication event log
* Windows System event log
Post relevant entries here. Do you have enough disk space? Where are you
backing up to? It could be a driver problem if using a tape device.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
NMiller wrote:
> Hi. I have a SQL Server 2000 server that runs backups
> every night on a handful of not very active databases.
> Recently, the server has crashed or hung each time,
> following successful backup of all but the last database.
> No error message, no warning. The system log shows a
> successful completion of the next-to-last backup. About
> six seconds later (usually) there is a system time stamp
> in the security log. Then the system just checks out,
> sometimes powered down, sometimes hung but still powered
> on. I have to manually reboot the system.
> Any suggestions on how to track down the problem?
> Thanks!
> Nora Miller
> Portland OR

No comments:

Post a Comment