MS SQL Server - SQL DB CHECK Error descriprion

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL DB CHECK Error descriprion

Wacek

2005-09-30, 3:23 am

I have message (from DB CHECK job):
DBCC CHECKDB (KXP) executed by NT AUTHORITY\SYSTEM found 10 errors and
repaired 0 errors.
Where can I read description of this errors?

Best regards
Wacek
(sorry for my 'african' english)

doller

2005-09-30, 3:23 am

Hi ,
U can use this

DBCC CHECKDB
( 'database_name'
[ , NOINDEX
| { REPAIR_ALLOW_DATA_LO
SS
| REPAIR_FAST
| REPAIR_REBUILD
} ]
) [ WITH { [ ALL_ERRORMSGS ]
[ , [ NO_INFOMSGS ] ]
[ , [ TABLOCK ] ]
[ , [ ESTIMATEONLY ] ]
[ , [ PHYSICAL_ONLY ] ]
}
]

and read more in BOL

Sponsored Links