Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 SQLServer Error: 644 и Error 8908  [new]
32sasha
Member

Откуда:
Сообщений: 503
При попытке посмотреть историю появляется сообщение с ошибкой
Картинка с другого сайта.

Кроме этого постоянно в лог сыпятся ошибки Сообщение
[298] SQLServer Error: 644, Could not find the index entry for RID '16996740100' in index page (1:1658), index ID 0, database 'msdb'. [SQLSTATE HY000] (ConnExecuteCachableOp)

Помогите разобраться, уже давно не занимался SQL а тут попросили так как сервер постоянно тормозит.
Куда смотреть и что делать не знаю.
Заранее спасибо.

SQL Server 2000 - 8.00.760 (Intel X86) sp3
26 мар 14, 18:38    [15791037]     Ответить | Цитировать Сообщить модератору
 Re: SQLServer Error: 644 и Error 8908  [new]
o-o
Guest
прогнать dbcc checkdb на msdb?
26 мар 14, 18:50    [15791098]     Ответить | Цитировать Сообщить модератору
 Re: SQLServer Error: 644 и Error 8908  [new]
32sasha
Member

Откуда:
Сообщений: 503
после применения к msdb
DBCC CHECKDB;
GO

получил вот такой результат
+
DBCC results for 'msdb'.
DBCC results for 'sysobjects'.
There are 553 rows in 10 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 304 rows in 13 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 3820 rows in 124 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 519 rows in 177 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 234 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 18 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 3186 rows in 18 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 33 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'sysjobschedules'.
There are 14 rows in 1 pages for object 'sysjobschedules'.
DBCC results for 'RTblIfaceMem'.
There are 1189 rows in 9 pages for object 'RTblIfaceMem'.
DBCC results for 'backupfile'.
There are 35035 rows in 757 pages for object 'backupfile'.
DBCC results for 'syscategories'.
There are 19 rows in 1 pages for object 'syscategories'.
DBCC results for 'systargetservers'.
There are 0 rows in 0 pages for object 'systargetservers'.
DBCC results for 'RTblWorkspaceItems'.
There are 0 rows in 0 pages for object 'RTblWorkspaceItems'.
DBCC results for 'restorehistory'.
There are 20 rows in 1 pages for object 'restorehistory'.
DBCC results for 'systargetservergroups'.
There are 0 rows in 0 pages for object 'systargetservergroups'.
DBCC results for 'RTblDatabaseVersion'.
There are 1 rows in 1 pages for object 'RTblDatabaseVersion'.
DBCC results for 'systargetservergroupmembers'.
There are 0 rows in 0 pages for object 'systargetservergroupmembers'.
DBCC results for 'sysalerts'.
There are 9 rows in 1 pages for object 'sysalerts'.
DBCC results for 'RTblDTSProps'.
There are 0 rows in 0 pages for object 'RTblDTSProps'.
DBCC results for 'RTblVersionAdminInfo'.
There are 2333 rows in 31 pages for object 'RTblVersionAdminInfo'.
DBCC results for 'restorefile'.
There are 40 rows in 2 pages for object 'restorefile'.
DBCC results for 'sysoperators'.
There are 0 rows in 0 pages for object 'sysoperators'.
DBCC results for 'sysnotifications'.
There are 0 rows in 0 pages for object 'sysnotifications'.
DBCC results for 'RTblParameterDef'.
There are 136 rows in 1 pages for object 'RTblParameterDef'.
DBCC results for 'restorefilegroup'.
There are 20 rows in 2 pages for object 'restorefilegroup'.
DBCC results for 'systaskids'.
There are 0 rows in 0 pages for object 'systaskids'.
DBCC results for 'syscachedcredentials'.
There are 1 rows in 1 pages for object 'syscachedcredentials'.
DBCC results for 'RTblIfaceHier'.
There are 3349 rows in 18 pages for object 'RTblIfaceHier'.
DBCC results for 'logmarkhistory'.
There are 0 rows in 0 pages for object 'logmarkhistory'.
DBCC results for 'RTblNamedObj'.
There are 2196 rows in 22 pages for object 'RTblNamedObj'.
DBCC results for 'sysdtscategories'.
There are 3 rows in 1 pages for object 'sysdtscategories'.
DBCC results for 'RTblClassExtension'.
There are 69 rows in 1 pages for object 'RTblClassExtension'.
DBCC results for 'sysdtspackages'.
There are 128 rows in 6 pages for object 'sysdtspackages'.
DBCC results for 'DTA_input'.
There are 4 rows in 1 pages for object 'DTA_input'.
DBCC results for 'DTA_progress'.
There are 11 rows in 1 pages for object 'DTA_progress'.
DBCC results for 'RTblTypeInfo'.
There are 0 rows in 0 pages for object 'RTblTypeInfo'.
DBCC results for 'DTA_output'.
There are 4 rows in 1 pages for object 'DTA_output'.
DBCC results for 'sysdtspackagelog'.
There are 0 rows in 0 pages for object 'sysdtspackagelog'.
DBCC results for 'RTblScriptDefs'.
There are 0 rows in 0 pages for object 'RTblScriptDefs'.
DBCC results for 'RTblOLPProps'.
There are 0 rows in 0 pages for object 'RTblOLPProps'.
DBCC results for 'sysdtssteplog'.
There are 0 rows in 0 pages for object 'sysdtssteplog'.
DBCC results for 'RTblEnumerationDef'.
There are 0 rows in 0 pages for object 'RTblEnumerationDef'.
DBCC results for 'DTA_tuninglog'.
There are 25 rows in 1 pages for object 'DTA_tuninglog'.
DBCC results for 'sysdtstasklog'.
There are 0 rows in 0 pages for object 'sysdtstasklog'.
DBCC results for 'DTA_reports_database'.
There are 9 rows in 1 pages for object 'DTA_reports_database'.
DBCC results for 'RTblSumInfo'.
There are 0 rows in 0 pages for object 'RTblSumInfo'.
DBCC results for 'RTblMDSProps'.
There are 0 rows in 0 pages for object 'RTblMDSProps'.
DBCC results for 'DTA_reports_partitionfunction'.
There are 0 rows in 0 pages for object 'DTA_reports_partitionfunction'.
DBCC results for 'RTblEnumerationValueDef'.
There are 0 rows in 0 pages for object 'RTblEnumerationValueDef'.
DBCC results for 'DTA_reports_partitionscheme'.
There are 0 rows in 0 pages for object 'DTA_reports_partitionscheme'.
DBCC results for 'RTblUMLProps'.
There are 0 rows in 0 pages for object 'RTblUMLProps'.
DBCC results for 'DTA_reports_table'.
There are 492 rows in 6 pages for object 'DTA_reports_table'.
DBCC results for 'DTA_reports_tableview'.
There are 0 rows in 0 pages for object 'DTA_reports_tableview'.
DBCC results for 'sysdbmaintplans'.
There are 1 rows in 1 pages for object 'sysdbmaintplans'.
DBCC results for 'DTA_reports_query'.
There are 8 rows in 1 pages for object 'DTA_reports_query'.
DBCC results for 'DTA_reports_querytable'.
There are 17 rows in 1 pages for object 'DTA_reports_querytable'.
DBCC results for 'sysdbmaintplan_jobs'.
There are 0 rows in 0 pages for object 'sysdbmaintplan_jobs'.
DBCC results for 'DTA_reports_querydatabase'.
There are 9 rows in 1 pages for object 'DTA_reports_querydatabase'.
DBCC results for 'RTblUMXProps'.
There are 0 rows in 0 pages for object 'RTblUMXProps'.
DBCC results for 'sysdbmaintplan_databases'.
There are 0 rows in 0 pages for object 'sysdbmaintplan_databases'.
DBCC results for 'DTA_reports_index'.
There are 698 rows in 11 pages for object 'DTA_reports_index'.
DBCC results for 'RTblSIMProps'.
There are 0 rows in 0 pages for object 'RTblSIMProps'.
DBCC results for 'sysdbmaintplan_history'.
There are 0 rows in 0 pages for object 'sysdbmaintplan_history'.
DBCC results for 'RTblGENProps'.
There are 0 rows in 0 pages for object 'RTblGENProps'.
DBCC results for 'DTA_reports_queryindex'.
There are 35 rows in 1 pages for object 'DTA_reports_queryindex'.
DBCC results for 'DTA_reports_column'.
There are 1891 rows in 14 pages for object 'DTA_reports_column'.
DBCC results for 'DTA_reports_indexcolumn'.
There are 59 rows in 1 pages for object 'DTA_reports_indexcolumn'.
DBCC results for 'RTblDTMProps'.
There are 0 rows in 0 pages for object 'RTblDTMProps'.
DBCC results for 'DTA_reports_querycolumn'.
There are 56 rows in 1 pages for object 'DTA_reports_querycolumn'.
DBCC results for 'log_shipping_primaries'.
There are 0 rows in 0 pages for object 'log_shipping_primaries'.
DBCC results for 'log_shipping_secondaries'.
There are 0 rows in 0 pages for object 'log_shipping_secondaries'.
DBCC results for 'RTblDBMProps'.
There are 0 rows in 0 pages for object 'RTblDBMProps'.
DBCC results for 'RTblEQMProps'.
There are 0 rows in 0 pages for object 'RTblEQMProps'.
DBCC results for 'log_shipping_monitor'.
There are 0 rows in 0 pages for object 'log_shipping_monitor'.
DBCC results for 'mswebtasks'.
There are 0 rows in 0 pages for object 'mswebtasks'.
DBCC results for 'log_shipping_databases'.
There are 0 rows in 0 pages for object 'log_shipping_databases'.
DBCC results for 'log_shipping_plans'.
There are 0 rows in 0 pages for object 'log_shipping_plans'.
DBCC results for 'RTblVersions'.
There are 2333 rows in 27 pages for object 'RTblVersions'.
DBCC results for 'log_shipping_plan_databases'.
There are 0 rows in 0 pages for object 'log_shipping_plan_databases'.
DBCC results for 'log_shipping_plan_history'.
There are 0 rows in 0 pages for object 'log_shipping_plan_history'.
DBCC results for 'RTblDBXProps'.
There are 0 rows in 0 pages for object 'RTblDBXProps'.
DBCC results for 'RTblRelships'.
There are 6922 rows in 146 pages for object 'RTblRelships'.
DBCC results for 'RTblSites'.
There are 44 rows in 1 pages for object 'RTblSites'.
DBCC results for 'RTblProps'.
There are 393 rows in 3 pages for object 'RTblProps'.
DBCC results for 'RTblRelshipProps'.
There are 28 rows in 1 pages for object 'RTblRelshipProps'.
DBCC results for 'RTblPropDefs'.
There are 797 rows in 10 pages for object 'RTblPropDefs'.
DBCC results for 'RTblRelColDefs'.
There are 320 rows in 4 pages for object 'RTblRelColDefs'.
DBCC results for 'RTblIfaceDefs'.
There are 453 rows in 5 pages for object 'RTblIfaceDefs'.
DBCC results for 'backupmediaset'.
There are 8551 rows in 89 pages for object 'backupmediaset'.
DBCC results for 'sqlagent_info'.
There are 0 rows in 0 pages for object 'sqlagent_info'.
DBCC results for 'RTblClassDefs'.
There are 537 rows in 5 pages for object 'RTblClassDefs'.
DBCC results for 'sysdownloadlist'.
There are 0 rows in 0 pages for object 'sysdownloadlist'.
DBCC results for 'backupmediafamily'.
There are 8551 rows in 169 pages for object 'backupmediafamily'.
DBCC results for 'sysjobhistory'.
Сообщение 8934, уровень 16, состояние 2, строка 1
Table error: Object ID 2073058421, index ID 1. The high key value on page (1:1600) (level 0) is not less than the low key value in the parent (1:7447), slot 43 of the next page (1:4298).
Сообщение 8979, уровень 16, состояние 1, строка 1
Table error: Object ID 2073058421, index ID 1. Page (1:1615) is missing references from parent (unknown) and previous (page (1:4298)) nodes. Possible bad root entry in sysindexes.
Сообщение 8977, уровень 16, состояние 1, строка 1
Table error: Object ID 2073058421, index ID 1. Parent node for page (1:1616) was not encountered.
Сообщение 8934, уровень 16, состояние 2, строка 1
Table error: Object ID 2073058421, index ID 1. The high key value on page (1:1658) (level 0) is not less than the low key value in the parent (1:7447), slot 50 of the next page (1:1662).
Сообщение 8935, уровень 16, состояние 1, строка 1
Table error: Object ID 2073058421, index ID 1. The previous link (1:4930) on page (1:1658) does not match the previous page (1:1656) that the parent (1:7447), slot 49 expects for this page.
Сообщение 8934, уровень 16, состояние 2, строка 1
Table error: Object ID 2073058421, index ID 1. The high key value on page (1:1899) (level 0) is not less than the low key value in the parent (1:7447), slot 41 of the next page (1:2602).
Сообщение 8935, уровень 16, состояние 1, строка 1
Table error: Object ID 2073058421, index ID 1. The previous link (1:2062) on page (1:1899) does not match the previous page (1:2063) that the parent (1:7447), slot 40 expects for this page.
Сообщение 8935, уровень 16, состояние 1, строка 1
Table error: Object ID 2073058421, index ID 1. The previous link (1:10252) on page (1:2062) does not match the previous page (1:725) that the parent (1:7447), slot 1 expects for this page.
Сообщение 8934, уровень 16, состояние 2, строка 1
Table error: Object ID 2073058421, index ID 1. The high key value on page (1:2602) (level 0) is not less than the low key value in the parent (1:7447), slot 42 of the next page (1:1600).
Сообщение 8935, уровень 16, состояние 1, строка 1
Table error: Object ID 2073058421, index ID 1. The previous link (1:2063) on page (1:4299) does not match the previous page (1:4298) that the parent (1:7447), slot 44 expects for this page.
Сообщение 8935, уровень 16, состояние 1, строка 1
Table error: Object ID 2073058421, index ID 1. The previous link (1:1656) on page (1:4541) does not match the previous page (1:1662) that the parent (1:7447), slot 51 expects for this page.
Сообщение 8934, уровень 16, состояние 2, строка 1
Table error: Object ID 2073058421, index ID 1. The high key value on page (1:4930) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:1658).
Сообщение 8935, уровень 16, состояние 1, строка 1
Table error: Object ID 2073058421, index ID 1. The previous link (1:725) on page (1:5167) does not match the previous page (1:2062) that the parent (1:7447), slot 2 expects for this page.
Сообщение 8934, уровень 16, состояние 2, строка 1
Table error: Object ID 2073058421, index ID 1. The high key value on page (1:10252) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:2062).
There are 26998 rows in 2364 pages for object 'sysjobhistory'.
CHECKDB found 0 allocation errors and 14 consistency errors in table 'sysjobhistory' (object ID 2073058421).
DBCC results for 'sysjobs'.
There are 13 rows in 1 pages for object 'sysjobs'.
DBCC results for 'RTblTFMProps'.
There are 0 rows in 0 pages for object 'RTblTFMProps'.
DBCC results for 'RTblRelshipDefs'.
There are 144 rows in 1 pages for object 'RTblRelshipDefs'.
DBCC results for 'backupset'.
There are 17567 rows in 766 pages for object 'backupset'.
DBCC results for 'sysjobservers'.
There are 13 rows in 1 pages for object 'sysjobservers'.
DBCC results for 'RTblTypeLibs'.
There are 17 rows in 1 pages for object 'RTblTypeLibs'.
DBCC results for 'sysjobsteps'.
There are 17 rows in 1 pages for object 'sysjobsteps'.
CHECKDB found 0 allocation errors and 14 consistency errors in database 'msdb'.
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (msdb ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Подскажите пожалуйста какие должны быть дальнейшие мои действия
26 мар 14, 18:58    [15791121]     Ответить | Цитировать Сообщить модератору
 Re: SQLServer Error: 644 и Error 8908  [new]
Гавриленко Сергей Алексеевич
Member

Откуда: Moscow
Сообщений: 37147
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (msdb ).

А вообще, желательно из бэкапа восстанавливать не битую базу.
26 мар 14, 19:05    [15791144]     Ответить | Цитировать Сообщить модератору
 Re: SQLServer Error: 644 и Error 8908  [new]
o-o
Guest
DBCC CHECKDB (repair_rebuild)
26 мар 14, 19:05    [15791147]     Ответить | Цитировать Сообщить модератору
 Re: SQLServer Error: 644 и Error 8908  [new]
32sasha
Member

Откуда:
Сообщений: 503
Как ввести в одно пользовательский режим msdb ?
+
Сообщение 7919, уровень 16, состояние 2, строка 1
Repair statement not processed. Database needs to be in single user mode.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
26 мар 14, 20:23    [15791448]     Ответить | Цитировать Сообщить модератору
 Re: SQLServer Error: 644 и Error 8908  [new]
Гавриленко Сергей Алексеевич
Member

Откуда: Moscow
Сообщений: 37147
Точно так же, как и любую другую базу данных: командой alter database.
26 мар 14, 20:24    [15791454]     Ответить | Цитировать Сообщить модератору
 Re: SQLServer Error: 644 и Error 8908  [new]
32sasha
Member

Откуда:
Сообщений: 503
Так ?
USE msdb;
GO
ALTER DATABASE msdb
SET SINGLE_USER;
GO

DBCC CHECKDB (msdb, repair_rebuild) ;
GO

ALTER DATABASE msdb
SET MULTI_USER;
GO
26 мар 14, 20:41    [15791555]     Ответить | Цитировать Сообщить модератору
 Re: SQLServer Error: 644 и Error 8908  [new]
32sasha
Member

Откуда:
Сообщений: 503
После выполнения скрипта получил вот такой результат
+
Server: Msg 1505, Level 16, State 1, Line 1
CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 1. Most significant primary key is '288666'.
DBCC results for 'msdb'.
DBCC results for 'sysobjects'.
There are 553 rows in 10 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 304 rows in 13 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 3820 rows in 124 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 519 rows in 177 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 234 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 18 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 3186 rows in 18 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 33 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'sysjobschedules'.
There are 14 rows in 1 pages for object 'sysjobschedules'.
DBCC results for 'RTblIfaceMem'.
There are 1189 rows in 9 pages for object 'RTblIfaceMem'.
DBCC results for 'backupfile'.
There are 35047 rows in 757 pages for object 'backupfile'.
DBCC results for 'syscategories'.
There are 19 rows in 1 pages for object 'syscategories'.
DBCC results for 'systargetservers'.
There are 0 rows in 0 pages for object 'systargetservers'.
DBCC results for 'RTblWorkspaceItems'.
There are 0 rows in 0 pages for object 'RTblWorkspaceItems'.
DBCC results for 'restorehistory'.
There are 20 rows in 1 pages for object 'restorehistory'.
DBCC results for 'systargetservergroups'.
There are 0 rows in 0 pages for object 'systargetservergroups'.
DBCC results for 'RTblDatabaseVersion'.
There are 1 rows in 1 pages for object 'RTblDatabaseVersion'.
DBCC results for 'systargetservergroupmembers'.
There are 0 rows in 0 pages for object 'systargetservergroupmembers'.
DBCC results for 'sysalerts'.
There are 9 rows in 1 pages for object 'sysalerts'.
DBCC results for 'RTblDTSProps'.
There are 0 rows in 0 pages for object 'RTblDTSProps'.
DBCC results for 'RTblVersionAdminInfo'.
There are 2333 rows in 31 pages for object 'RTblVersionAdminInfo'.
DBCC results for 'restorefile'.
There are 40 rows in 2 pages for object 'restorefile'.
DBCC results for 'sysoperators'.
There are 0 rows in 0 pages for object 'sysoperators'.
DBCC results for 'sysnotifications'.
There are 0 rows in 0 pages for object 'sysnotifications'.
DBCC results for 'RTblParameterDef'.
There are 136 rows in 1 pages for object 'RTblParameterDef'.
DBCC results for 'restorefilegroup'.
There are 20 rows in 2 pages for object 'restorefilegroup'.
DBCC results for 'systaskids'.
There are 0 rows in 0 pages for object 'systaskids'.
DBCC results for 'syscachedcredentials'.
There are 1 rows in 1 pages for object 'syscachedcredentials'.
DBCC results for 'RTblIfaceHier'.
There are 3349 rows in 18 pages for object 'RTblIfaceHier'.
DBCC results for 'logmarkhistory'.
There are 0 rows in 0 pages for object 'logmarkhistory'.
DBCC results for 'RTblNamedObj'.
There are 2196 rows in 22 pages for object 'RTblNamedObj'.
DBCC results for 'sysdtscategories'.
There are 3 rows in 1 pages for object 'sysdtscategories'.
DBCC results for 'RTblClassExtension'.
There are 69 rows in 1 pages for object 'RTblClassExtension'.
DBCC results for 'sysdtspackages'.
There are 128 rows in 6 pages for object 'sysdtspackages'.
DBCC results for 'DTA_input'.
There are 4 rows in 1 pages for object 'DTA_input'.
DBCC results for 'DTA_progress'.
There are 11 rows in 1 pages for object 'DTA_progress'.
DBCC results for 'RTblTypeInfo'.
There are 0 rows in 0 pages for object 'RTblTypeInfo'.
DBCC results for 'DTA_output'.
There are 4 rows in 1 pages for object 'DTA_output'.
DBCC results for 'sysdtspackagelog'.
There are 0 rows in 0 pages for object 'sysdtspackagelog'.
DBCC results for 'RTblScriptDefs'.
There are 0 rows in 0 pages for object 'RTblScriptDefs'.
DBCC results for 'RTblOLPProps'.
There are 0 rows in 0 pages for object 'RTblOLPProps'.
DBCC results for 'sysdtssteplog'.
There are 0 rows in 0 pages for object 'sysdtssteplog'.
DBCC results for 'RTblEnumerationDef'.
There are 0 rows in 0 pages for object 'RTblEnumerationDef'.
DBCC results for 'DTA_tuninglog'.
There are 25 rows in 1 pages for object 'DTA_tuninglog'.
DBCC results for 'sysdtstasklog'.
There are 0 rows in 0 pages for object 'sysdtstasklog'.
DBCC results for 'DTA_reports_database'.
There are 9 rows in 1 pages for object 'DTA_reports_database'.
DBCC results for 'RTblSumInfo'.
There are 0 rows in 0 pages for object 'RTblSumInfo'.
DBCC results for 'RTblMDSProps'.
There are 0 rows in 0 pages for object 'RTblMDSProps'.
DBCC results for 'DTA_reports_partitionfunction'.
There are 0 rows in 0 pages for object 'DTA_reports_partitionfunction'.
DBCC results for 'RTblEnumerationValueDef'.
There are 0 rows in 0 pages for object 'RTblEnumerationValueDef'.
DBCC results for 'DTA_reports_partitionscheme'.
There are 0 rows in 0 pages for object 'DTA_reports_partitionscheme'.
DBCC results for 'RTblUMLProps'.
There are 0 rows in 0 pages for object 'RTblUMLProps'.
DBCC results for 'DTA_reports_table'.
There are 492 rows in 6 pages for object 'DTA_reports_table'.
DBCC results for 'DTA_reports_tableview'.
There are 0 rows in 0 pages for object 'DTA_reports_tableview'.
DBCC results for 'sysdbmaintplans'.
There are 1 rows in 1 pages for object 'sysdbmaintplans'.
DBCC results for 'DTA_reports_query'.
There are 8 rows in 1 pages for object 'DTA_reports_query'.
DBCC results for 'DTA_reports_querytable'.
There are 17 rows in 1 pages for object 'DTA_reports_querytable'.
DBCC results for 'sysdbmaintplan_jobs'.
There are 0 rows in 0 pages for object 'sysdbmaintplan_jobs'.
DBCC results for 'DTA_reports_querydatabase'.
There are 9 rows in 1 pages for object 'DTA_reports_querydatabase'.
DBCC results for 'RTblUMXProps'.
There are 0 rows in 0 pages for object 'RTblUMXProps'.
DBCC results for 'sysdbmaintplan_databases'.
There are 0 rows in 0 pages for object 'sysdbmaintplan_databases'.
DBCC results for 'DTA_reports_index'.
There are 698 rows in 11 pages for object 'DTA_reports_index'.
DBCC results for 'RTblSIMProps'.
There are 0 rows in 0 pages for object 'RTblSIMProps'.
DBCC results for 'sysdbmaintplan_history'.
There are 0 rows in 0 pages for object 'sysdbmaintplan_history'.
DBCC results for 'RTblGENProps'.
There are 0 rows in 0 pages for object 'RTblGENProps'.
DBCC results for 'DTA_reports_queryindex'.
There are 35 rows in 1 pages for object 'DTA_reports_queryindex'.
DBCC results for 'DTA_reports_column'.
There are 1891 rows in 14 pages for object 'DTA_reports_column'.
DBCC results for 'DTA_reports_indexcolumn'.
There are 59 rows in 1 pages for object 'DTA_reports_indexcolumn'.
DBCC results for 'RTblDTMProps'.
There are 0 rows in 0 pages for object 'RTblDTMProps'.
DBCC results for 'DTA_reports_querycolumn'.
There are 56 rows in 1 pages for object 'DTA_reports_querycolumn'.
DBCC results for 'log_shipping_primaries'.
There are 0 rows in 0 pages for object 'log_shipping_primaries'.
DBCC results for 'log_shipping_secondaries'.
There are 0 rows in 0 pages for object 'log_shipping_secondaries'.
DBCC results for 'RTblDBMProps'.
There are 0 rows in 0 pages for object 'RTblDBMProps'.
DBCC results for 'RTblEQMProps'.
There are 0 rows in 0 pages for object 'RTblEQMProps'.
DBCC results for 'log_shipping_monitor'.
There are 0 rows in 0 pages for object 'log_shipping_monitor'.
DBCC results for 'mswebtasks'.
There are 0 rows in 0 pages for object 'mswebtasks'.
DBCC results for 'log_shipping_databases'.
There are 0 rows in 0 pages for object 'log_shipping_databases'.
DBCC results for 'log_shipping_plans'.
There are 0 rows in 0 pages for object 'log_shipping_plans'.
DBCC results for 'RTblVersions'.
There are 2333 rows in 27 pages for object 'RTblVersions'.
DBCC results for 'log_shipping_plan_databases'.
There are 0 rows in 0 pages for object 'log_shipping_plan_databases'.
DBCC results for 'log_shipping_plan_history'.
There are 0 rows in 0 pages for object 'log_shipping_plan_history'.
DBCC results for 'RTblDBXProps'.
There are 0 rows in 0 pages for object 'RTblDBXProps'.
DBCC results for 'RTblRelships'.
There are 6922 rows in 146 pages for object 'RTblRelships'.
DBCC results for 'RTblSites'.
There are 44 rows in 1 pages for object 'RTblSites'.
DBCC results for 'RTblProps'.
There are 393 rows in 3 pages for object 'RTblProps'.
DBCC results for 'RTblRelshipProps'.
There are 28 rows in 1 pages for object 'RTblRelshipProps'.
DBCC results for 'RTblPropDefs'.
Server: Msg 8934, Level 16, State 2, Line 2
Table error: Object ID 2073058421, index ID 1. The high key value on page (1:1600) (level 0) is not less than the low key value in the parent (1:7447), slot 43 of the next page (1:4298).
Server: Msg 8979, Level 16, State 1, Line 2
Table error: Object ID 2073058421, index ID 1. Page (1:1615) is missing references from parent (unknown) and previous (page (1:4298)) nodes. Possible bad root entry in sysindexes.
Server: Msg 8977, Level 16, State 1, Line 2
Table error: Object ID 2073058421, index ID 1. Parent node for page (1:1616) was not encountered.
Server: Msg 8934, Level 16, State 1, Line 2
Table error: Object ID 2073058421, index ID 1. The high key value on page (1:1658) (level 0) is not less than the low key value in the parent (1:7447), slot 50 of the next page (1:1662).
There are 797 rows in 10 pages for object 'RTblPropDefs'.
DBCC results for 'RTblRelColDefs'.
There are 320 rows in 4 pages for object 'RTblRelColDefs'.
DBCC results for 'RTblIfaceDefs'.
There are 453 rows in 5 pages for object 'RTblIfaceDefs'.
DBCC results for 'backupmediaset'.
There are 8551 rows in 89 pages for object 'backupmediaset'.
DBCC results for 'sqlagent_info'.
There are 0 rows in 0 pages for object 'sqlagent_info'.
DBCC results for 'RTblClassDefs'.
There are 537 rows in 5 pages for object 'RTblClassDefs'.
DBCC results for 'sysdownloadlist'.
There are 0 rows in 0 pages for object 'sysdownloadlist'.
DBCC results for 'backupmediafamily'.
There are 8551 rows in 169 pages for object 'backupmediafamily'.
DBCC results for 'sysjobhistory'.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Server: Msg 8935, Level 16, State 1, Line 2
Table error: Object ID 2073058421, index ID 1. The previous link (1:4930) on page (1:1658) does not match the previous page (1:1656) that the parent (1:7447), slot 49 expects for this page.
Server: Msg 8934, Level 16, State 1, Line 2
Table error: Object ID 2073058421, index ID 1. The high key value on page (1:1899) (level 0) is not less than the low key value in the parent (1:7447), slot 41 of the next page (1:2602).
Server: Msg 8935, Level 16, State 1, Line 2
Table error: Object ID 2073058421, index ID 1. The previous link (1:2062) on page (1:1899) does not match the previous page (1:2063) that the parent (1:7447), slot 40 expects for this page.
Server: Msg 8935, Level 16, State 1, Line 2
Table error: Object ID 2073058421, index ID 1. The previous link (1:10273) on page (1:2062) does not match the previous page (1:725) that the parent (1:7447), slot 1 expects for this page.
Server: Msg 8934, Level 16, State 1, Line 2
Table error: Object ID 2073058421, index ID 1. The high key value on page (1:2602) (level 0) is not less than the low key value in the parent (1:7447), slot 42 of the next page (1:1600).
Server: Msg 8935, Level 16, State 1, Line 2
Table error: Object ID 2073058421, index ID 1. The previous link (1:2063) on page (1:4299) does not match the previous page (1:4298) that the parent (1:7447), slot 44 expects for this page.
Server: Msg 8935, Level 16, State 1, Line 2
Table error: Object ID 2073058421, index ID 1. The previous link (1:1656) on page (1:4541) does not match the previous page (1:1662) that the parent (1:7447), slot 51 expects for this page.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Could not repair this error.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Server: Msg 8934, Level 16, State 2, Line 2
Table error: Object ID 2073058421, index ID 1. The high key value on page (1:4930) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:1658).
Server: Msg 8935, Level 16, State 1, Line 2
Table error: Object ID 2073058421, index ID 1. The previous link (1:725) on page (1:5167) does not match the previous page (1:2062) that the parent (1:7447), slot 2 expects for this page.
Server: Msg 8934, Level 16, State 1, Line 2
Table error: Object ID 2073058421, index ID 1. The high key value on page (1:10273) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:2062).
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
Repairing this error requires other errors to be corrected first.
There are 27053 rows in 2370 pages for object 'sysjobhistory'.
CHECKDB found 0 allocation errors and 14 consistency errors in table 'sysjobhistory' (object ID 2073058421).
DBCC results for 'sysjobs'.
There are 13 rows in 1 pages for object 'sysjobs'.
DBCC results for 'RTblTFMProps'.
There are 0 rows in 0 pages for object 'RTblTFMProps'.
DBCC results for 'RTblRelshipDefs'.
There are 144 rows in 1 pages for object 'RTblRelshipDefs'.
DBCC results for 'backupset'.
There are 17573 rows in 767 pages for object 'backupset'.
DBCC results for 'sysjobservers'.
There are 13 rows in 1 pages for object 'sysjobservers'.
DBCC results for 'RTblTypeLibs'.
There are 17 rows in 1 pages for object 'RTblTypeLibs'.
DBCC results for 'sysjobsteps'.
There are 17 rows in 1 pages for object 'sysjobsteps'.
CHECKDB found 0 allocation errors and 14 consistency errors in database 'msdb'.
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (msdb repair_rebuild).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
The statement has been terminated.


После этого проверил еще раз базу msdb
DBCC CHECKDB;
GO
Результат
+
DBCC results for 'msdb'.
DBCC results for 'sysobjects'.
There are 553 rows in 10 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 304 rows in 13 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 3820 rows in 124 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 519 rows in 177 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 234 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 18 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 3186 rows in 18 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 33 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'sysjobschedules'.
There are 14 rows in 1 pages for object 'sysjobschedules'.
DBCC results for 'RTblIfaceMem'.
There are 1189 rows in 9 pages for object 'RTblIfaceMem'.
DBCC results for 'backupfile'.
There are 35047 rows in 757 pages for object 'backupfile'.
DBCC results for 'syscategories'.
There are 19 rows in 1 pages for object 'syscategories'.
DBCC results for 'systargetservers'.
There are 0 rows in 0 pages for object 'systargetservers'.
DBCC results for 'RTblWorkspaceItems'.
There are 0 rows in 0 pages for object 'RTblWorkspaceItems'.
DBCC results for 'restorehistory'.
There are 20 rows in 1 pages for object 'restorehistory'.
DBCC results for 'systargetservergroups'.
There are 0 rows in 0 pages for object 'systargetservergroups'.
DBCC results for 'RTblDatabaseVersion'.
There are 1 rows in 1 pages for object 'RTblDatabaseVersion'.
DBCC results for 'systargetservergroupmembers'.
There are 0 rows in 0 pages for object 'systargetservergroupmembers'.
DBCC results for 'sysalerts'.
There are 9 rows in 1 pages for object 'sysalerts'.
DBCC results for 'RTblDTSProps'.
There are 0 rows in 0 pages for object 'RTblDTSProps'.
DBCC results for 'RTblVersionAdminInfo'.
There are 2333 rows in 31 pages for object 'RTblVersionAdminInfo'.
DBCC results for 'restorefile'.
There are 40 rows in 2 pages for object 'restorefile'.
DBCC results for 'sysoperators'.
There are 0 rows in 0 pages for object 'sysoperators'.
DBCC results for 'sysnotifications'.
There are 0 rows in 0 pages for object 'sysnotifications'.
DBCC results for 'RTblParameterDef'.
There are 136 rows in 1 pages for object 'RTblParameterDef'.
DBCC results for 'restorefilegroup'.
There are 20 rows in 2 pages for object 'restorefilegroup'.
DBCC results for 'systaskids'.
There are 0 rows in 0 pages for object 'systaskids'.
DBCC results for 'syscachedcredentials'.
There are 1 rows in 1 pages for object 'syscachedcredentials'.
DBCC results for 'RTblIfaceHier'.
There are 3349 rows in 18 pages for object 'RTblIfaceHier'.
DBCC results for 'logmarkhistory'.
There are 0 rows in 0 pages for object 'logmarkhistory'.
DBCC results for 'RTblNamedObj'.
There are 2196 rows in 22 pages for object 'RTblNamedObj'.
DBCC results for 'sysdtscategories'.
There are 3 rows in 1 pages for object 'sysdtscategories'.
DBCC results for 'RTblClassExtension'.
There are 69 rows in 1 pages for object 'RTblClassExtension'.
DBCC results for 'sysdtspackages'.
There are 128 rows in 6 pages for object 'sysdtspackages'.
DBCC results for 'DTA_input'.
There are 4 rows in 1 pages for object 'DTA_input'.
DBCC results for 'DTA_progress'.
There are 11 rows in 1 pages for object 'DTA_progress'.
DBCC results for 'RTblTypeInfo'.
There are 0 rows in 0 pages for object 'RTblTypeInfo'.
DBCC results for 'DTA_output'.
There are 4 rows in 1 pages for object 'DTA_output'.
DBCC results for 'sysdtspackagelog'.
There are 0 rows in 0 pages for object 'sysdtspackagelog'.
DBCC results for 'RTblScriptDefs'.
There are 0 rows in 0 pages for object 'RTblScriptDefs'.
DBCC results for 'RTblOLPProps'.
There are 0 rows in 0 pages for object 'RTblOLPProps'.
DBCC results for 'sysdtssteplog'.
There are 0 rows in 0 pages for object 'sysdtssteplog'.
DBCC results for 'RTblEnumerationDef'.
There are 0 rows in 0 pages for object 'RTblEnumerationDef'.
DBCC results for 'DTA_tuninglog'.
There are 25 rows in 1 pages for object 'DTA_tuninglog'.
DBCC results for 'sysdtstasklog'.
There are 0 rows in 0 pages for object 'sysdtstasklog'.
DBCC results for 'DTA_reports_database'.
There are 9 rows in 1 pages for object 'DTA_reports_database'.
DBCC results for 'RTblSumInfo'.
There are 0 rows in 0 pages for object 'RTblSumInfo'.
DBCC results for 'RTblMDSProps'.
There are 0 rows in 0 pages for object 'RTblMDSProps'.
DBCC results for 'DTA_reports_partitionfunction'.
There are 0 rows in 0 pages for object 'DTA_reports_partitionfunction'.
DBCC results for 'RTblEnumerationValueDef'.
There are 0 rows in 0 pages for object 'RTblEnumerationValueDef'.
DBCC results for 'DTA_reports_partitionscheme'.
There are 0 rows in 0 pages for object 'DTA_reports_partitionscheme'.
DBCC results for 'RTblUMLProps'.
There are 0 rows in 0 pages for object 'RTblUMLProps'.
DBCC results for 'DTA_reports_table'.
There are 492 rows in 6 pages for object 'DTA_reports_table'.
DBCC results for 'DTA_reports_tableview'.
There are 0 rows in 0 pages for object 'DTA_reports_tableview'.
DBCC results for 'sysdbmaintplans'.
There are 1 rows in 1 pages for object 'sysdbmaintplans'.
DBCC results for 'DTA_reports_query'.
There are 8 rows in 1 pages for object 'DTA_reports_query'.
DBCC results for 'DTA_reports_querytable'.
There are 17 rows in 1 pages for object 'DTA_reports_querytable'.
DBCC results for 'sysdbmaintplan_jobs'.
There are 0 rows in 0 pages for object 'sysdbmaintplan_jobs'.
DBCC results for 'DTA_reports_querydatabase'.
There are 9 rows in 1 pages for object 'DTA_reports_querydatabase'.
DBCC results for 'RTblUMXProps'.
There are 0 rows in 0 pages for object 'RTblUMXProps'.
DBCC results for 'sysdbmaintplan_databases'.
There are 0 rows in 0 pages for object 'sysdbmaintplan_databases'.
DBCC results for 'DTA_reports_index'.
There are 698 rows in 11 pages for object 'DTA_reports_index'.
DBCC results for 'RTblSIMProps'.
There are 0 rows in 0 pages for object 'RTblSIMProps'.
DBCC results for 'sysdbmaintplan_history'.
There are 0 rows in 0 pages for object 'sysdbmaintplan_history'.
DBCC results for 'RTblGENProps'.
There are 0 rows in 0 pages for object 'RTblGENProps'.
DBCC results for 'DTA_reports_queryindex'.
There are 35 rows in 1 pages for object 'DTA_reports_queryindex'.
DBCC results for 'DTA_reports_column'.
There are 1891 rows in 14 pages for object 'DTA_reports_column'.
DBCC results for 'DTA_reports_indexcolumn'.
There are 59 rows in 1 pages for object 'DTA_reports_indexcolumn'.
DBCC results for 'RTblDTMProps'.
There are 0 rows in 0 pages for object 'RTblDTMProps'.
DBCC results for 'DTA_reports_querycolumn'.
There are 56 rows in 1 pages for object 'DTA_reports_querycolumn'.
DBCC results for 'log_shipping_primaries'.
There are 0 rows in 0 pages for object 'log_shipping_primaries'.
DBCC results for 'log_shipping_secondaries'.
There are 0 rows in 0 pages for object 'log_shipping_secondaries'.
DBCC results for 'RTblDBMProps'.
There are 0 rows in 0 pages for object 'RTblDBMProps'.
DBCC results for 'RTblEQMProps'.
There are 0 rows in 0 pages for object 'RTblEQMProps'.
DBCC results for 'log_shipping_monitor'.
There are 0 rows in 0 pages for object 'log_shipping_monitor'.
DBCC results for 'mswebtasks'.
There are 0 rows in 0 pages for object 'mswebtasks'.
DBCC results for 'log_shipping_databases'.
There are 0 rows in 0 pages for object 'log_shipping_databases'.
DBCC results for 'log_shipping_plans'.
There are 0 rows in 0 pages for object 'log_shipping_plans'.
DBCC results for 'RTblVersions'.
There are 2333 rows in 27 pages for object 'RTblVersions'.
DBCC results for 'log_shipping_plan_databases'.
There are 0 rows in 0 pages for object 'log_shipping_plan_databases'.
DBCC results for 'log_shipping_plan_history'.
There are 0 rows in 0 pages for object 'log_shipping_plan_history'.
DBCC results for 'RTblDBXProps'.
There are 0 rows in 0 pages for object 'RTblDBXProps'.
DBCC results for 'RTblRelships'.
There are 6922 rows in 146 pages for object 'RTblRelships'.
DBCC results for 'RTblSites'.
There are 44 rows in 1 pages for object 'RTblSites'.
DBCC results for 'RTblProps'.
There are 393 rows in 3 pages for object 'RTblProps'.
DBCC results for 'RTblRelshipProps'.
There are 28 rows in 1 pages for object 'RTblRelshipProps'.
DBCC results for 'RTblPropDefs'.
There are 797 rows in 10 pages for object 'RTblPropDefs'.
DBCC results for 'RTblRelColDefs'.
There are 320 rows in 4 pages for object 'RTblRelColDefs'.
DBCC results for 'RTblIfaceDefs'.
There are 453 rows in 5 pages for object 'RTblIfaceDefs'.
DBCC results for 'backupmediaset'.
There are 8551 rows in 89 pages for object 'backupmediaset'.
Server: Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 2073058421, index ID 1. The high key value on page (1:1600) (level 0) is not less than the low key value in the parent (1:7447), slot 43 of the next page (1:4298).
Server: Msg 8979, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. Page (1:1615) is missing references from parent (unknown) and previous (page (1:4298)) nodes. Possible bad root entry in sysindexes.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. Parent node for page (1:1616) was not encountered.
Server: Msg 8933, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. The low key value on page (1:1658) (level 0) is not >= the key value in the parent (1:7447) slot 56.
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. The high key value on page (1:1658) (level 0) is not less than the low key value in the parent (1:7447), slot 50 of the next page (1:1662).
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. The high key value on page (1:1899) (level 0) is not less than the low key value in the parent (1:7447), slot 41 of the next page (1:2602).
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. The previous link (1:2062) on page (1:1899) does not match the previous page (1:2063) that the parent (1:7447), slot 40 expects for this page.
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. The previous link (1:10273) on page (1:2062) does not match the previous page (1:725) that the parent (1:7447), slot 1 expects for this page.
DBCC results for 'sqlagent_info'.
There are 0 rows in 0 pages for object 'sqlagent_info'.
DBCC results for 'RTblClassDefs'.
There are 537 rows in 5 pages for object 'RTblClassDefs'.
DBCC results for 'sysdownloadlist'.
There are 0 rows in 0 pages for object 'sysdownloadlist'.
DBCC results for 'backupmediafamily'.
There are 8551 rows in 169 pages for object 'backupmediafamily'.
DBCC results for 'sysjobhistory'.
Server: Msg 8934, Level 16, State 2, Line 1
Table error: Object ID 2073058421, index ID 1. The high key value on page (1:2602) (level 0) is not less than the low key value in the parent (1:7447), slot 42 of the next page (1:1600).
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. The previous link (1:2063) on page (1:4299) does not match the previous page (1:4298) that the parent (1:7447), slot 44 expects for this page.
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. The previous link (1:1656) on page (1:4541) does not match the previous page (1:1662) that the parent (1:7447), slot 51 expects for this page.
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. The high key value on page (1:4930) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:1658).
Server: Msg 8935, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. The previous link (1:725) on page (1:5167) does not match the previous page (1:2062) that the parent (1:7447), slot 2 expects for this page.
Server: Msg 8934, Level 16, State 1, Line 1
Table error: Object ID 2073058421, index ID 1. The high key value on page (1:10273) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:2062).
There are 27053 rows in 2370 pages for object 'sysjobhistory'.
CHECKDB found 0 allocation errors and 14 consistency errors in table 'sysjobhistory' (object ID 2073058421).
DBCC results for 'sysjobs'.
There are 13 rows in 1 pages for object 'sysjobs'.
DBCC results for 'RTblTFMProps'.
There are 0 rows in 0 pages for object 'RTblTFMProps'.
DBCC results for 'RTblRelshipDefs'.
There are 144 rows in 1 pages for object 'RTblRelshipDefs'.
DBCC results for 'backupset'.
There are 17573 rows in 767 pages for object 'backupset'.
DBCC results for 'sysjobservers'.
There are 13 rows in 1 pages for object 'sysjobservers'.
DBCC results for 'RTblTypeLibs'.
There are 17 rows in 1 pages for object 'RTblTypeLibs'.
DBCC results for 'sysjobsteps'.
There are 17 rows in 1 pages for object 'sysjobsteps'.
CHECKDB found 0 allocation errors and 14 consistency errors in database 'msdb'.
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (msdb ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.


Что можете еще подсказать, куда дальше двигаться?
Из бекапа не удаться восстановится так как эта ошибка уже больше полу года.
27 мар 14, 11:52    [15793691]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить