Re: Konsistenzprüfung fehlgeschlagen

Hallo Olaf,
danke nun hat es geklappt.

Nun habe ich gleich die nächste Frage. Wie rep ich die DB nun?

CHECKDB found 0 allocation errors and 2 consistency errors in database 'msdb'.
repair_allow_data_loss 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.

Als Fehler wird:

There are 0 rows in 0 pages for object 'syscachedcredentials'.
DBCC results for 'restorefilegroup'.
Server: Nachr.-Nr. 8928, Schweregrad 16, Status 1, Zeile 2
Object ID 2101582525, index ID 0: Page (1:842) could not be processed. See
other errors for details.
Server: Nachr.-Nr. 8944, Schweregrad 16, Status 1, Zeile 2
Table error: Object ID 2101582525, index ID 0, page (1:842), row 48. Test
(ColumnOffsets <= (nextRec - pRec)) failed. Values are 60160 and 134.
There are 1732 rows in 12 pages for object 'restorefilegroup'.
DBCC results for 'logmarkhistory'.

angezeigt.


Gruß

Mathias

PS: Hier noch das gesamte Protokoll, falls ich was übersehen habe.
DBCC results for 'msdb'.
DBCC results for 'sysobjects'.
There are 280 rows in 6 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 105 rows in 4 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 1567 rows in 26 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 357 rows in 107 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 116 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 13 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 1630 rows in 8 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 12 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 'backupset'.
There are 6434 rows in 281 pages for object 'backupset'.
DBCC results for 'sysjobschedules'.
There are 0 rows in 0 pages for object 'sysjobschedules'.
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 'backupfile'.
There are 12584 rows in 248 pages for object 'backupfile'.
DBCC results for 'systargetservergroups'.
There are 0 rows in 0 pages for object 'systargetservergroups'.
DBCC results for 'systargetservergroupmembers'.
There are 0 rows in 0 pages for object 'systargetservergroupmembers'.
DBCC results for 'restorehistory'.
There are 1732 rows in 23 pages for object 'restorehistory'.
DBCC results for 'sysalerts'.
There are 9 rows in 1 pages for object 'sysalerts'.
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 'restorefile'.
There are 3464 rows in 46 pages for object 'restorefile'.
DBCC results for 'systaskids'.
There are 0 rows in 0 pages for object 'systaskids'.
DBCC results for 'syscachedcredentials'.
There are 0 rows in 0 pages for object 'syscachedcredentials'.
DBCC results for 'restorefilegroup'.
Server: Nachr.-Nr. 8928, Schweregrad 16, Status 1, Zeile 2
Object ID 2101582525, index ID 0: Page (1:842) could not be processed. See
other errors for details.
Server: Nachr.-Nr. 8944, Schweregrad 16, Status 1, Zeile 2
Table error: Object ID 2101582525, index ID 0, page (1:842), row 48. Test
(ColumnOffsets <= (nextRec - pRec)) failed. Values are 60160 and 134.
There are 1732 rows in 12 pages for object 'restorefilegroup'.
DBCC results for 'logmarkhistory'.
There are 0 rows in 0 pages for object 'logmarkhistory'.
DBCC results for 'sysdtscategories'.
There are 3 rows in 1 pages for object 'sysdtscategories'.
DBCC results for 'sysdtspackages'.
There are 0 rows in 0 pages for object 'sysdtspackages'.
DBCC results for 'sysdtspackagelog'.
There are 0 rows in 0 pages for object 'sysdtspackagelog'.
DBCC results for 'sysdtssteplog'.
There are 0 rows in 0 pages for object 'sysdtssteplog'.
DBCC results for 'sysdtstasklog'.
There are 0 rows in 0 pages for object 'sysdtstasklog'.
DBCC results for 'sysdbmaintplans'.
There are 1 rows in 1 pages for object 'sysdbmaintplans'.
DBCC results for 'sysdbmaintplan_jobs'.
There are 0 rows in 0 pages for object 'sysdbmaintplan_jobs'.
DBCC results for 'sysdbmaintplan_databases'.
There are 0 rows in 0 pages for object 'sysdbmaintplan_databases'.
DBCC results for 'sysdbmaintplan_history'.
There are 0 rows in 0 pages for object 'sysdbmaintplan_history'.
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 'mswebtasks'.
There are 0 rows in 0 pages for object 'mswebtasks'.
DBCC results for 'sqlagent_info'.
There are 0 rows in 0 pages for object 'sqlagent_info'.
DBCC results for 'sysdownloadlist'.
There are 0 rows in 0 pages for object 'sysdownloadlist'.
DBCC results for 'backupmediaset'.
There are 6434 rows in 67 pages for object 'backupmediaset'.
DBCC results for 'sysjobhistory'.
There are 0 rows in 0 pages for object 'sysjobhistory'.
DBCC results for 'sysjobs'.
There are 0 rows in 0 pages for object 'sysjobs'.
DBCC results for 'backupmediafamily'.
There are 6376 rows in 112 pages for object 'backupmediafamily'.
CHECKDB found 0 allocation errors and 2 consistency errors in table
'backupmediafamily' (object ID 2101582525).
DBCC results for 'sysjobservers'.
There are 0 rows in 0 pages for object 'sysjobservers'.
DBCC results for 'sysjobsteps'.
There are 0 rows in 0 pages for object 'sysjobsteps'.
CHECKDB found 0 allocation errors and 2 consistency errors in database 'msdb'.
repair_allow_data_loss 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.



"Olaf Pietsch" wrote:

Hallo Matthias,
"Mathias Amenda" <MathiasAmenda@xxxxxxxxxxxxxxxxxxxxxxxxx> schrieb im
Newsbeitrag news:3B385DFB-952D-4BA2-BF25-26E52FC327ED@xxxxxxxxxxxxxxxx

Christoph, wie für man den das DBCC manuell aus? Bin doch leihe..
Als SQL war bei der erstinstalltion die standrat SQL von dem SBS 2003
Standard mit bei. Danach wurde letzten Sommer eien neues WWS auf SQL
2005
Standard installiert. Nicht die kostenlose Express Version.

Du hast die Standard Edition des SQL Servers, siehe Programmgruppe
Microsoft
SQL Server 2005, starte dort SQL Server Management Studio

....

nur waren meine Aussagen nicht richtig. Es wurde ein SQL 2000 installiert
und zusätzlich MS Visual C++ 2005.
Sorry.

Bei SQL 2000 gibt es ein Enterprise Manger. Dort gibt es zwei DB´s die von
dem WWS und die von Veritas. Dann geht es mit den verschieden DB weiter
und
bei mir hört es auf.

Wie gehts da weiter.
Um die dbcc prüfung manuell auszuführen, nimm bei sQL Server 2006 das Tool
"Query Analyzer". Ist in der gleichen Programmgruppe zu finden wie der
Enterprise Manager.

Nach dem Start verbinde Dich mit Deinem Server. Du müsstest dann den Object
Browser und eine Query/Abfrage-Fenster sehen. Dort gib den Befehlstext ein:
use master;
dbcc checkdb ( msdb );
und drücke den Button mit dem grünen Pfeil oder Funtionstaste <F5>.

--
Gruß Olaf
Ich unterstütze PASS Deutschland e.V. (http://www.sqlpass.de)
Blog (http://www.sqlpass.de/PASSUserBlogs/tabid/178/Default.aspx?BlogID=3)
Regionalgruppe Köln/Bonn/Düsseldorf
(http://www.sqlpass.de/Regionalgruppen/KoelnBonnDuesseldorf/tabid/81/Default.aspx)


.