C:\MSSQL7\DATA\TEMPDB.MDF

[Laura2]

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.

 

[Laura2]

Here is the SP3 file that is corrupt:

OFO: Error during backup. Set has been aborted. <<<<-------------------------------------------------------------------------------------
WARNING: "\sql2ksp3\msolap\Install\_sys1.hdr" is a corrupt file.
This file cannot verify.

 

[mrdenny]

Do a chkdsk on your c drive. Sounds like the c drive is going bad.

That file is probably still in use. Try moving the tempdb to another drive.

http://support.microsoft.com/default.aspx?scid=kb;en-us;187824

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

Donate to Katrina relief

 

[Laura2]

Thanks Denny. I'll run a chkdsk over the weekend. It takes forever!

Laura