June 28, 2003 at 1:49 pm
Hi there, I just restored a database from DLT backup. I get the following error when I query one of my tables:
Server: Msg 823, Level 24, State 2, Line 1
I/O error (bad page ID) detected during read at offset 0x000011d6d66000 in file 'I:\MSSQL\DATA\EARTHLINK_DATA.MDF'.
Also, the system event log has these errors:
Application popup: Windows - Delayed Write Failed : Windows was unable to save all the data for the file \Device\HarddiskDmVolumes\PhysicalDmVolumes\BlockVolume4\$Mft. The data has been lost. This error may be caused by a failure of your computer hardware or network connection. Please try to save this file elsewhere.
And this message:
{Lost Delayed-Write Data} The system was attempting to transfer file data from buffers to . The write operation failed, and only some of the data may have been written to the file.
Is this a bad drive? How can I make sure? Thanks in advance for your help.
June 28, 2003 at 8:08 pm
Could be something went wrong with cached data, I don't think its necessarily a bad drive, though a chkdsk is in order. Have you run dbcc yet? Might want to run a backup first if it will complete.
Andy
June 30, 2003 at 9:43 am
Try copying the backup down to disk first and then restoring the database.
John Zacharkan
John Zacharkan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply