July 3, 2005 at 8:29 pm
I received this error ''I/O error (bad page ID) detected during read at offset 0x00000073200000 in file 'c:\TEMP\IDS\InjuryDTS.mdf" everytime I run my script to access the source table form InjuryDTS database.I tried already execute dbcc reindex and update statistic to that particular table but in return i received another error message "Could not continue scan with NOLOCK due to data movement."
How can I resolved this??
Anybody..pls advise
July 5, 2005 at 10:48 am
Are you trying to directly access the mdf file from a dts package?
If so, you should not be. It is a database file.
If you need to access a table in the database, then put a connection to the db, NOT the mdf file.
July 5, 2005 at 7:53 pm
No i'm not trying to access the .mdf file directly. I knew the file extension is a database file.I have created the connection in my DTS Package but the table that I need to DTS is giving me that error.other tables is ok.
July 6, 2005 at 10:07 am
Not too sure what the problem is, I'm afraid.
Can you access the table directly from query analyzer using the same user account?
July 6, 2005 at 8:33 pm
Nope. It gave me the same error even when I just run a SELECT.. statement. but if I open the table through Enterprise Manager, I can see the table content but as I scroll down more, the same error will pop up to my screen.
July 8, 2005 at 9:59 am
It sounds very much like corruption to me.
Try running some diagnostic scripts to see if that fixes it.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply