| Author |
Topic |
|
cips
Starting Member
4 Posts |
 Posted - 2010-04-16 : 16:44:39
|
| Hello.Greetings to everyone.Here is my problem: I migrated recently a DB from a SQL 2000 to a 2005 (export/import).All is working fine, except a strange message I find in the sql server log file:I/O error 23(error not found) detected during read at offset 0x00000000b88000 in file 'U:\sql\data\msdbdata.mdf'I find this one time a day. The really strange thing is that this path is not one of the path I'm using to store data files (located on a different disk), so I don't understand from where this message is coming.Nothing is registered in the event viewer. I ran the checkDb on all the DB and no errors were reported. All looks fine, and actually all the DB are running fine. I checked the sys.master_files table, but no evidence of this file.I'm really puzzled. How can I understand what is causing this error message? How can I track this down?Thanks for your help.Cips |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-17 : 08:13:36
|
| Scheduled Task? Especially if the error occurs at the same time each day. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-17 : 14:53:41
|
| "looks like msdb to me"Oops! I didn't spot that ..."I ran the checkDb on all the DB and no errors were reported"Including the system databases MASTER and MSDB? If not I recommend that you do that. |
|
|
|
cips
Starting Member
4 Posts |
Posted - 2010-04-18 : 12:39:05
|
quote:
Originally posted by Kristen
Scheduled Task? Especially if the error occurs at the same time each day.
Yes, this is what I thought, but what should I look for? I don't find anything pointing to this folder... |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-18 : 14:03:30
|
| Sorry, wasn't clear in my reply. If it happens at, say, 01:15 every day then look for a scheduled task that runs at that time (rather than trying to find one that is referencing that disk location).Did you do a DBCC CHECKDB on the MSDB & MASTER databases? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-04-18 : 14:23:25
|
| Can you query sys.master_files, see if there are any entries with that path.--Gail ShawSQL Server MVP |
|
|
|
cips
Starting Member
4 Posts |
Posted - 2010-04-19 : 04:50:32
|
quote:
Originally posted by Kristen
Sorry, wasn't clear in my reply. If it happens at, say, 01:15 every day then look for a scheduled task that runs at that time (rather than trying to find one that is referencing that disk location).Did you do a DBCC CHECKDB on the MSDB & MASTER databases?
Yes, I ran the checkDB on both and 0 errors were reported. I tried to look in scheduled jobs/at jobs, but I can't find anything obvious... |
|
|
|
cips
Starting Member
4 Posts |
Posted - 2010-04-19 : 04:52:47
|
quote:
Originally posted by GilaMonster
Can you query sys.master_files, see if there are any entries with that path.
Yes, I tried, but no evidence of this path there. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
ghost DB file