Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jch04
Starting Member
9 Posts |
 Posted - 2009-02-18 : 02:59:31
|
| Hello to all,I am getting the follwint error:Msg 823, Level 24, State 7, Procedure sync_attendance, Line 10I/O error (bad page ID) detected during read at offset 0x000000004f2000in file 'C:\Program Files\Microsoft SQL Server\MSSQL\data\tempdb.mdf'.I have already checked the size of tempdb.mdf which is not full, and I moved the tempdb.mdf to another location in the disk, but the problem remains.Any ideas?thanks in advance! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jch04
Starting Member
9 Posts |
Posted - 2009-02-19 : 03:05:04
|
| CHECKDB found 0 allocation errors and 0 consistency errors in database 'tempdb'. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-19 : 06:59:58
|
quote:
Originally posted by jch04
Hello to all,I am getting the follwint error:Msg 823, Level 24, State 7, Procedure sync_attendance, Line 10I/O error (bad page ID) detected during read at offset 0x000000004f2000in file 'C:\Program Files\Microsoft SQL Server\MSSQL\data\tempdb.mdf'.I have already checked the size of tempdb.mdf which is not full, and I moved the tempdb.mdf to another location in the disk, but the problem remains.Any ideas?thanks in advance!
I have seen this error before in my system. Have you applied recent services packs and patches? Have you spread TempDB data files accross number of cores? Is it in separate Write intensive disk(like RAID 10) disk? |
|
|
|
|
|
|
|
|
Msg 823 I/O error (bad page ID detected during rea