大家看看这个报错信息是什么意思?Msg 1124, Level 22, State 102, Line 1
Table error: Page (1:77614). Test (offset + len < PAGESIZE) failed. Slot 108, offset 0x16f is invalid.
Msg 3316, Level 21, State 1, Line 1
During undo of a logged operation in database 'NewBoxLog', an error occurred at log record ID (1380:347529:371). The row was not found. Restore the database from a full backup, or repair the database.
Msg 3314, Level 21, State 4, Line 1
During undoing of a logged operation in database 'NewBoxLog', an error occurred at log record ID (1380:347529:371). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair the database.
Msg 9001, Level 21, State 5, Line 1
The log for database 'NewBoxLog' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
Msg 3314, Level 21, State 4, Line 1
During undoing of a logged operation in database 'NewBoxLog', an error occurred at log record ID (1380:347529:371). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair the database.
Msg 9001, Level 21, State 1, Line 1
The log for database 'NewBoxLog' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
Msg 3314, Level 21, State 5, Line 1
During undoing of a logged operation in database 'NewBoxLog', an error occurred at log record ID (1380:125889:2). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair the database.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Table error: Page (1:77614). Test (offset + len < PAGESIZE) failed. Slot 108, offset 0x16f is invalid.
Msg 3316, Level 21, State 1, Line 1
During undo of a logged operation in database 'NewBoxLog', an error occurred at log record ID (1380:347529:371). The row was not found. Restore the database from a full backup, or repair the database.
Msg 3314, Level 21, State 4, Line 1
During undoing of a logged operation in database 'NewBoxLog', an error occurred at log record ID (1380:347529:371). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair the database.
Msg 9001, Level 21, State 5, Line 1
The log for database 'NewBoxLog' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
Msg 3314, Level 21, State 4, Line 1
During undoing of a logged operation in database 'NewBoxLog', an error occurred at log record ID (1380:347529:371). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair the database.
Msg 9001, Level 21, State 1, Line 1
The log for database 'NewBoxLog' is not available. Check the event log for related error messages. Resolve any errors and restart the database.
Msg 3314, Level 21, State 5, Line 1
During undoing of a logged operation in database 'NewBoxLog', an error occurred at log record ID (1380:125889:2). Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair the database.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
检查指定数据库中所有对象的分配、结构和逻辑完整性。
检查指定数据库中的所有对象的分配和结构完整性。权限
DBCC CHECKDB 权限默认授予 sysadmin 固定服务器角色或 db_owner 固定数据库角色的成员且不可转让。示例
A. 检查当前数据库和 pubs 数据库
下例对当前数据库和 pubs 数据库执行 DBCC CHECKDB。-- Check the current database.
DBCC CHECKDB
GO
-- Check the pubs database without nonclustered indexes.
DBCC CHECKDB ('pubs', NOINDEX)
GOB. 检查当前数据库,禁止显示信息性消息
下例检查当前数据库,并禁止显示所有信息性消息。DBCC CHECKDB WITH NO_INFOMSGS
GO