We upgraded to SQL 2000 from 7 and everything has been running fine until yesterday when the following error started to pop up:
DATE/TIME: 9/8/2005 4:10:56 PM
DESCRIPTION: Error: 823, Severity: 24, State: 4
I/O error 2(The system cannot find the file specified.) detected during write at offset 0x00000015fd2000 in file 'C:\MSSQL7\DATA\TEMPDB.MDF'.
COMMENT: (None)
JOB RUN: (None)
We have multiple queries running all day long. We've run the CHECKDB as stated on the Microsoft site with no errors produced on any of our databases. We've also upgraded from SP 3 to 4 although when we did a backup of the server prior to running the service pack, there was an SP 3 file that was corrupt and would not back up. This file is for SQL 7 and I'm not clear if it's even in use. I'm not sure what else to do. Does anyone have any suggestions?
Thank you,
Laura.
DATE/TIME: 9/8/2005 4:10:56 PM
DESCRIPTION: Error: 823, Severity: 24, State: 4
I/O error 2(The system cannot find the file specified.) detected during write at offset 0x00000015fd2000 in file 'C:\MSSQL7\DATA\TEMPDB.MDF'.
COMMENT: (None)
JOB RUN: (None)
We have multiple queries running all day long. We've run the CHECKDB as stated on the Microsoft site with no errors produced on any of our databases. We've also upgraded from SP 3 to 4 although when we did a backup of the server prior to running the service pack, there was an SP 3 file that was corrupt and would not back up. This file is for SQL 7 and I'm not clear if it's even in use. I'm not sure what else to do. Does anyone have any suggestions?
Thank you,
Laura.