The Index Allocation Map (IAM) page is pointed to by the next pointer of IAM page in object ID , index ID, partition ID, alloc unit ID , but it was not detected in the scan.
SQL Server mdf 文件损坏修复,恢复,DBCC CheckDB检查出现如下错误:
DBCC results for 'UFDATA_001_2012'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.
消息 2575,级别 16,状态 1,第 9 行
The Index Allocation Map (IAM) page (1:228416) is pointed to by the next pointer of IAM page (0:0) in object ID 0, index ID -1, partition ID 0, alloc unit ID 72057600660865024 (type Unknown), but it was not detected in the scan.
The error has been repaired.
CHECKDB found 1 allocation errors and 0 consistency errors not associated with any single object.
CHECKDB fixed 1 allocation errors and 0 consistency errors not associated with any single object.
1.重要数据要经常备份,【异地备份重要数据,一天一次】。备份方案推荐:
秒备份。
2.建议将重要数据备份到Linux主机(linux开启ftp服务,定时将重要数据备份到linux的ftp),可以确保数据安全。
SQL数据库可以做恢复修复,QQ : 80554803,TEL : 18620906802 (微信)
SQL database can be restored and repaired, wechat: 18620906802, Skype: jogewang, Email:Data700@qq.com