开始时对表的索引进行了调整,把全局索引改为了分区索引,因为是测试,反复操作了几次,第二天就遇到一个奇怪的问题。
这个表的索引无法删除和创建了,总是报错‘对象 ID 2058542467 的元数据不一致。无法修复此错误,不能继续处理此对象’,试图用dbcc checktable修复,还是无法修复。
最后没办法,准备删除表重建,但是表无法删除,还是一样报错,大家有没有遇到这样的情况,求解决办法
这个表的索引无法删除和创建了,总是报错‘对象 ID 2058542467 的元数据不一致。无法修复此错误,不能继续处理此对象’,试图用dbcc checktable修复,还是无法修复。
最后没办法,准备删除表重建,但是表无法删除,还是一样报错,大家有没有遇到这样的情况,求解决办法
1。用dbcc checkdb恢复,失败
2。用dbcc checktable恢复,失败
3。用dbcc dbreindex恢复,失败
4。用dbcc checkalloc恢复,失败
5。手动删除表索引,失败
6。手动删除表,失败
我把部分错误日志贴上来,大家看看有没有什么办法日期,源,严重性,消息
09/08/2011 14:00:23,spid53,未知,Setting database option MULTI_USER to ON for database netsecdb_ether_50.
09/08/2011 13:46:58,spid53,未知,DoMiniDump () encountered error (0x800703E6) - 内存位置访问无效。
09/08/2011 13:46:58,spid53,未知,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
09/08/2011 13:46:58,spid53,未知,Stack Signature for the dump is 0x00000019
09/08/2011 13:46:58,spid53,未知,* Short Stack Dump
09/08/2011 13:46:58,spid53,未知,* -------------------------------------------------------------------------------
09/08/2011 13:46:58,spid53,未知,* *******************************************************************************
09/08/2011 13:46:58,spid53,未知,*
09/08/2011 13:46:58,spid53,未知,* DBCC CheckDB (netsecdb_ether_50 <c/> REPAIR_ALLOW_DATA_LOSS)
09/08/2011 13:46:58,spid53,未知,* Input Buffer 136 bytes -
09/08/2011 13:46:58,spid53,未知,*
09/08/2011 13:46:58,spid53,未知,* DBCC database corruption
09/08/2011 13:46:58,spid53,未知,*
09/08/2011 13:46:58,spid53,未知,* 09/08/11 13:46:58 spid 53
09/08/2011 13:46:58,spid53,未知,* BEGIN STACK DUMP:
09/08/2011 13:46:58,spid53,未知,*
09/08/2011 13:46:58,spid53,未知,* *******************************************************************************
09/08/2011 13:46:58,spid53,未知,**Dump thread - spid = 53<c/> PSS = 0x092A9380<c/> EC = 0x092A9388
09/08/2011 13:46:58,spid53,未知,Using 'dbghelp.dll' version '4.0.5'
09/08/2011 13:46:58,spid53,未知,DBCC CHECKDB (netsecdb_ether_50<c/> repair_allow_data_loss) executed by WANGAN-7E4NZGWI\Administrator found 48 errors and repaired 39 errors. Elapsed time: 0 hours 0 minutes 0 seconds.
09/08/2011 13:46:51,spid53,未知,DBCC CHECKTABLE (netsecdb_ether_50.dbo.net_dns<c/> repair_allow_data_loss) executed by WANGAN-7E4NZGWI\Administrator found 1 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 0 seconds.
09/08/2011 13:40:35,spid53,未知,Attempt to fetch logical page (25:2932) in database 16 failed. It belongs to allocation unit 72057594603372544 not to 72057594581286912.
09/08/2011 13:40:35,spid53,未知,错误: 605,严重性: 21,状态: 3。
09/08/2011 13:40:34,spid53,未知,Attempt to fetch logical page (25:2932) in database 16 failed. It belongs to allocation unit 72057594603372544 not to 72057594581286912.
09/08/2011 13:40:34,spid53,未知,错误: 605,严重性: 21,状态: 3。
09/08/2011 13:40:32,spid53,未知,Attempt to fetch logical page (25:2932) in database 16 failed. It belongs to allocation unit 72057594603372544 not to 72057594581286912.
09/08/2011 13:40:32,spid53,未知,错误: 605,严重性: 21,状态: 3。
09/08/2011 13:40:26,spid53,未知,Attempt to fetch logical page (25:2932) in database 16 failed. It belongs to allocation unit 72057594603372544 not to 72057594581286912.
09/08/2011 13:40:26,spid53,未知,错误: 605,严重性: 21,状态: 3。
09/08/2011 13:39:19,spid53,未知,A system assertion check has failed. Check the SQL Server error log for details. Typically<c/> an assertion failure is caused by a software bug or data corruption. To check for database corruption<c/> consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup<c/> a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support.
09/08/2011 13:39:19,spid53,未知,错误: 3624,严重性: 20,状态: 1。
09/08/2011 13:39:19,spid53,未知,SQL Server Assertion: File: <AllocPageRef.cpp><c/> line=62 Failed Assertion = 'aid == id'. This error may be timing-related. If the error persists after rerunning the statement<c/> use DBCC CHECKDB to check the database for structural integrity<c/> or restart the server to ensure in-memory data structures are not corrupted.
09/08/2011 13:39:19,spid53,未知,错误: 17066,严重性: 16,状态: 1。
09/08/2011 13:39:19,spid53,未知,DoMiniDump () encountered error (0x800703E6) - 内存位置访问无效。
09/08/2011 13:39:19,spid53,未知,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
09/08/2011 13:39:19,spid53,未知,Stack Signature for the dump is 0x8FA5072C
09/08/2011 13:39:19,spid53,未知,78132A47 Module(MSVCR80+00002A47)
09/08/2011 13:39:19,spid53,未知,781329BB Module(MSVCR80+000029BB)
09/08/2011 13:39:19,spid53,未知,010DACF1 Module(sqlservr+000DACF1)
09/08/2011 13:39:19,spid53,未知,010DAB54 Module(sqlservr+000DAB54)
09/08/2011 13:39:19,spid53,未知,010DAE8C Module(sqlservr+000DAE8C)
09/08/2011 13:39:19,spid53,未知,010DAF6C Module(sqlservr+000DAF6C)
09/08/2011 13:39:19,spid53,未知,01006609 Module(sqlservr+00006609)
09/08/2011 13:39:19,spid53,未知,010068F9 Module(sqlservr+000068F9)
09/08/2011 13:39:19,spid53,未知,010067D3 Module(sqlservr+000067D3)
09/08/2011 13:39:19,spid53,未知,01040EC3 Module(sqlservr+00040EC3)
09/08/2011 13:39:19,spid53,未知,010411FB Module(sqlservr+000411FB)
09/08/2011 13:39:19,spid53,未知,0102298A Module(sqlservr+0002298A)
09/08/2011 13:39:19,spid53,未知,01024644 Module(sqlservr+00024644)
09/08/2011 13:39:19,spid53,未知,01024083 Module(sqlservr+00024083)
09/08/2011 13:39:19,spid53,未知,011C16E9 Module(sqlservr+001C16E9)
09/08/2011 13:39:19,spid53,未知,012B4C6E Module(sqlservr+002B4C6E)
09/08/2011 13:39:19,spid53,未知,012B5801 Module(sqlservr+002B5801)
09/08/2011 13:39:19,spid53,未知,02275A90 Module(sqlservr+01275A90)
09/08/2011 13:39:19,spid53,未知,022768D0 Module(sqlservr+012768D0)
09/08/2011 13:39:19,spid53,未知,022762CF Module(sqlservr+012762CF)
09/08/2011 13:39:19,spid53,未知,019A1C0B Module(sqlservr+009A1C0B)
09/08/2011 13:39:19,spid53,未知,0199FD58 Module(sqlservr+0099FD58)
09/08/2011 13:39:19,spid53,未知,0199F6D7 Module(sqlservr+0099F6D7)
09/08/2011 13:39:19,spid53,未知,019A05DA Module(sqlservr+009A05DA)
09/08/2011 13:39:19,spid53,未知,0199E202 Module(sqlservr+0099E202)
09/08/2011 13:39:19,spid53,未知,0199E085 Module(sqlservr+0099E085)
09/08/2011 13:39:19,spid53,未知,0158ABD6 Module(sqlservr+0058ABD6)
09/08/2011 13:39:19,spid53,未知,0158B0A8 Module(sqlservr+0058B0A8)
09/08/2011 13:39:19,spid53,未知,0211B22F Module(sqlservr+0111B22F)
09/08/2011 13:39:19,spid53,未知,0211A550 Module(sqlservr+0111A550)
09/08/2011 13:39:19,spid53,未知,02050AAA Module(sqlservr+01050AAA)
09/08/2011 13:39:19,spid53,未知,021B2880 Module(sqlservr+011B2880)
09/08/2011 13:39:19,spid53,未知,021AE96C Module(sqlservr+011AE96C)
09/08/2011 13:39:19,spid53,未知,7C815DEA Module(kernel32+00015DEA)
09/08/2011 13:39:19,spid53,未知,* Short Stack Dump
09/08/2011 13:39:19,spid53,未知,* DBCC DBREINDEX ('net_dns' )
09/08/2011 13:39:19,spid53,未知,* Input Buffer 84 bytes -
09/08/2011 13:39:19,spid53,未知,*
09/08/2011 13:39:19,spid53,未知,* Process ID: 2464
09/08/2011 13:39:19,spid53,未知,* SPID: 53
09/08/2011 13:39:19,spid53,未知,* Expression: aid == id
09/08/2011 13:39:19,spid53,未知,* Location: AllocPageRef.cpp:62
09/08/2011 13:39:19,spid53,未知,*
09/08/2011 13:39:19,spid53,未知,* 09/08/11 13:39:19 spid 53
09/08/2011 13:39:19,spid53,未知,* BEGIN STACK DUMP:
09/08/2011 13:39:19,spid53,未知,*
09/08/2011 13:39:19,spid53,未知,* *******************************************************************************