How can you tell whether a DB is corrupt?

Hi group,
is the corruption of a database always associated with its being not able to
be accessed? If not, how can one tell, so that one can deal with the
corruption?
QS
You can run the DBCC commands to check the integrity of the database. See
DBCC CHECKDB in Books Online to start with.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Question on SQL" <qs@.who.com> wrote in message
news:uwDzqaihEHA.2540@.TK2MSFTNGP10.phx.gbl...
Hi group,
is the corruption of a database always associated with its being not able to
be accessed? If not, how can one tell, so that one can deal with the
corruption?
QS
|||Hi,
Most of the corruptions allow you to access the database. The error will
only come while you access the corruption part.
The corruption can be identified by running.
DBCC CHECKDB('dbname')
Thanks
Hari
MCDBA
"Question on SQL" <qs@.who.com> wrote in message
news:uwDzqaihEHA.2540@.TK2MSFTNGP10.phx.gbl...
> Hi group,
> is the corruption of a database always associated with its being not able
to
> be accessed? If not, how can one tell, so that one can deal with the
> corruption?
> QS
>
|||Thank you both for the response.
QS
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uF5xkdnhEHA.3632@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Hi,
> Most of the corruptions allow you to access the database. The error will
> only come while you access the corruption part.
> The corruption can be identified by running.
> DBCC CHECKDB('dbname')
> Thanks
> Hari
> MCDBA
> "Question on SQL" <qs@.who.com> wrote in message
> news:uwDzqaihEHA.2540@.TK2MSFTNGP10.phx.gbl...
able
> to
>