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 |
|
triemvo
Starting Member
3 Posts |
 Posted - 2006-04-11 : 23:45:04
|
| Hi allI have got some errors with my databse when try execute query.Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver][SQL Server]I/O error (bad page ID) detected during read at offset 0x000000000d4000 in file 'D:\mywebsite\asp\ocsbusiness\dbs\OCT.mdf'.I running dbcc checkdb on it. this is the resultServer: Msg 8928, Level 16, State 1, Line 1Object ID 14, index ID 2: Page (1:106) could not be processed. See other errors for details.Server: Msg 8909, Level 16, State 1, Line 1Table error: Object ID 3584, index ID 512, page ID (1:106). The PageId in the page header = (256:27139).......CHECKDB found 0 allocation errors and 2 consistency errors in database 'OCT'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (OCT).DBCC execution completed. If DBCC printed error messages, contact your system administrator.I cann't restore by database beacouse the other set backup i have is three month ago. So I try to run dbcc checkdb REPAIR_ALLOW_DATA_LOSS but it didn't workServer: Msg 170, Level 15, State 1, Line 1Line 1: Incorrect syntax near 'repair_allow_data_loss'.. Help me please, I need fix this errors soon.TriemV |
|
|
triemvo
Starting Member
3 Posts |
Posted - 2006-04-12 : 00:30:20
|
| I finish run dbcc checkdb ('OCT') with no_infomsgsThere is the messagesServer: Msg 8928, Level 16, State 1, Line 1Object ID 14, index ID 2: Page (1:106) could not be processed. See other errors for details.Server: Msg 8909, Level 16, State 1, Line 1Table error: Object ID 3584, index ID 512, page ID (1:106). The PageId in the page header = (256:27139).CHECKDB found 0 allocation errors and 1 consistency errors in table 'sysreferences' (object ID 14).CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 3584)' (object ID 3584).CHECKDB found 0 allocation errors and 2 consistency errors in database 'OCT'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (OCT).Then I try to run dbcc checkdb ('OCT', repair_allow_data_loss):( ...Server: Msg 7919, Level 16, State 2, Line 1Repair statement not processed. Database needs to be in single user mode.DBCC execution completed. If DBCC printed error messages, contact your system administrator.??????????????????????TriemV |
 |
|
|
ryanston
Microsoft SQL Server Product Team
89 Posts |
Posted - 2006-04-12 : 18:47:27
|
quote:
Originally posted by triemvo
I finish run dbcc checkdb ('OCT') with no_infomsgsThere is the messagesServer: Msg 8928, Level 16, State 1, Line 1Object ID 14, index ID 2: Page (1:106) could not be processed. See other errors for details.Server: Msg 8909, Level 16, State 1, Line 1Table error: Object ID 3584, index ID 512, page ID (1:106). The PageId in the page header = (256:27139).CHECKDB found 0 allocation errors and 1 consistency errors in table 'sysreferences' (object ID 14).CHECKDB found 0 allocation errors and 1 consistency errors in table '(Object ID 3584)' (object ID 3584).CHECKDB found 0 allocation errors and 2 consistency errors in database 'OCT'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (OCT).Then I try to run dbcc checkdb ('OCT', repair_allow_data_loss):( ...Server: Msg 7919, Level 16, State 2, Line 1Repair statement not processed. Database needs to be in single user mode.DBCC execution completed. If DBCC printed error messages, contact your system administrator.??????????????????????TriemV
You have to set your database in SINGLE_USER mode before running repair:ALTER DATABASE <foo> SET SINGLE_USERgoDBCC CHECKDB (<foo>, REPAIR_ALLOW_DATA_LOSS) GOI'd stronly recommend you check your hardware for errors. Do you have a valid backup? Why not restore it?----------------------Ryan StonecipherDeveloper, Microsoft SQL Server Storage Engine, DBCC(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-04-12 : 19:42:44
|
| do you have backups you can go to? Do you take incrmemental backups? data loss means just that, you will lose data and potentially totally screw up your database. -ec |
|
|
|
|
|
|
|
|
Bad page ID error :(