Re: Konsistenzprüfung fehlgeschlagen

Mathias Amenda wrote:
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.

Hallo Mathias,
das Thema ist auch in der Online-Dooku beschrieben. Versuch es mal mit
DBCC CHECKDB (msdb, REPAIR_ALLOW_DATA_LOSS)

Wobei Du auf jeden Fall sicherstellen solltest, dass Du noch eine alte Sicherung der msdb hast.

Einen schönen Tag noch,
Christoph
--
(Please post ALL replies to the newsgroup only unless indicated
otherwise)

.

Relevant Pages

  • Re: Help-Corrupt table
    ... table corruption that DBCC repairs will not fix so you must restore from ... >clustered, hypothetical index. ... >>BTW CHECKTABLE and CHECKDB are different if you check ...
    (microsoft.public.sqlserver.server)
  • Re: DBCC error 913
    ... You don't need to run DBCC CHECKALLOC as well as DBCC CHECKDB - CHECKDB ... >> I assume that you use ALTER DATABASE to set in single user mode... ... >>> This is simple DBCC script I am running on the server every sunday. ...
    (microsoft.public.sqlserver.server)
  • REPAIR_ALLOW_DATA_LOSS
    ... bringen die checkdb befehle zu akzeptieren. ... DBCC CHECKDB ... Database 'AE1' cannot be opened because some of the files ... Could not restart database 'AE1'. ...
    (microsoft.public.de.sqlserver)
  • =?Utf-8?Q?Re:_Konsistenzpr=C3=BCfung_fehlgeschl?= =?Utf-8?Q?agen?=
    ... Wie rep ich die DB nun? ... CHECKDB found 0 allocation errors and 2 consistency errors in database 'msdb'. ... DBCC execution completed. ... Als SQL war bei der erstinstalltion die standrat SQL von dem SBS 2003 ...
    (microsoft.public.de.sqlserver)
  • Sr DotNET Consultant | North Brook, IL | 8-10 months
    ... Duration: 8-10 Months ... like sysobjects, msdb, DBCC etc) ...
    (comp.lang.java.programmer)
Loading