DBCC CHECKDB

If error occur while testing the database via DBCC Checkdb command like
table corruption error so how can we solve this... or if any one have faced
any DBCC CheckDB error...
Thanks
Depends on the error you got, what do you have ?
Jens Suessmeyer.
http://www.sqlserver2005.de
"Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
news:uINdMsaUFHA.3544@.TK2MSFTNGP12.phx.gbl...
> If error occur while testing the database via DBCC Checkdb command like
> table corruption error so how can we solve this... or if any one have
> faced
> any DBCC CheckDB error...
> Thanks
>
|||I mean for knowledge !
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:#jnymxaUFHA.1944@.TK2MSFTNGP14.phx.gbl...
> Depends on the error you got, what do you have ?
> Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
> news:uINdMsaUFHA.3544@.TK2MSFTNGP12.phx.gbl...
>
|||I am asking this question for acknowledge... can you help me...
"Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:#jnymxaUFHA.1944@.TK2MSFTNGP14.phx.gbl...
> Depends on the error you got, what do you have ?
> Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Joh" <joh@.mailcity.com> schrieb im Newsbeitrag
> news:uINdMsaUFHA.3544@.TK2MSFTNGP12.phx.gbl...
>
|||Hi,
Incase if your DBCC CHECKDB comes out with allocation errors you could use
the REPAIR options along with CHECKDB command
to solve the error. You need to set the database to SINGLE USER mode to run
the REPAIR options. See the syntax usage in Books online.
Thanks
Hari
SQL Server MVP
"Joh" <joh@.mailcity.com> wrote in message
news:uINdMsaUFHA.3544@.TK2MSFTNGP12.phx.gbl...
> If error occur while testing the database via DBCC Checkdb command like
> table corruption error so how can we solve this... or if any one have
faced
> any DBCC CheckDB error...
> Thanks
>
|||Different errors will have different fixes. There's no one fix for all DBCC
CHECKDB reported errors.
joe.
"Joh" <joh@.mailcity.com> wrote in message
news:usmL6DbUFHA.3152@.TK2MSFTNGP12.phx.gbl...
>I mean for knowledge !
> "Jens Smeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
> in
> message news:#jnymxaUFHA.1944@.TK2MSFTNGP14.phx.gbl...
>
|||Please note that the repair option may result in lost data and there is no
way to tell if or how much. BOL has potential fixes for many errors that
can be reported by checkdb, others are documented in the knowledge base.
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.