October 16, 2003 at 12:30 pm
Hello,
I have a series of Jobs that automate Log, Differential and Database backups. This morning, these Jobs started failing. A look at the History of a particualar backup job shows the following message, and the message is similar to all backup Jobs that are failing:
"Executed as user: VALVERDE\sqlacct. I/O error 2(The system cannot find the file specified.) detected during write at offset 0x000000007b8000 in file 'F:\Central_Data\Central_Data_Data.MDF'. [SQLSTATE HY000] (Error 823). The step failed."
This looks to me like an I/O problem to the disk that might be occuring, maybe because of a power interruption to the machine on which SQL Server 2000 is installed. I have not been able to confirm power problems yet with our network people.
The problem does not occur after I stop and start the SQL Server and Agent Services.
Can anyone give me examples of when such an error might occur, and why just restarting the services would cause the problem to be resolved?
Thanks!
CSDunn
October 16, 2003 at 12:39 pm
I would check machine application/system logs to try to find out what happened exactly to your machine.
Beacuse your MDF was not available, SQL Server was unable to start your database. Restart SQL Server will allow it to start database properly.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply