• To determine if there are space allocation or structural integrity problems,  Database Command Console (DBCC) command.  There are 6 commands that determine the granularity of the checking such as CHECKTABLE for a single table or CHECKDB for everything.  See Books OnLine under DBCC CHECK

    Most of these checks have the option to repair but some of the options allow data loss.

    For Recovery, SQL Server natively supports database granularity and does not support recovery of an individual table.

    For table level recovery, there are third party tools such as Log P.I at http://www.logpi.com or Log Explorer at www.http://www.lumigent.com/products/le_sql.html

    SQL = Scarcely Qualifies as a Language