i found that the error is dated back to 2006, so the backup since then won't
be valid, right?

what does this mean: repair_allow_data_loss is the minimum repair level for
the errors found by DBCC CHECKDB (db_source noindex).

thank you


"Andrew J. Kelly" wrote:

> Unless this is a nonclustered index your best bet is to restore from the
> last known good backup. Do you have Torn Page Detection turned on for that
> db? If not you should so you can spot issues like this sooner. In any case
> have a look at this series from Paul Randal on checkdb and what your options
> are.
> http://www.sqlskills.com/blogs/paul/...y%2BAngle.aspx
>
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
>
> "tulip" <tulip@discussions.microsoft.com> wrote in message
> newsF042B2B-3DE5-455A-90C2-038534D6CEC7@microsoft.com...
> > we are running a maintainance plan on sql 2000 standard edition, got the
> > error,
> >
> > [2] Database db_source: Check Data Linkage...
> > [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8928: [Microsoft][ODBC
> > SQL
> > Server Driver][SQL Server]Object ID 1221579390, index ID 0: Page
> > (1:197116)
> > could not be processed. See other errors for details.
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID
> > 1221579390, index ID 0, page (1:197116).
> > Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are
> > 2057
> > and -1.
> > [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation
> > errors and 2 consistency errors in table 'xxx'(object ID 1221579390).
> > [Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation
> > errors and 2 consistency errors in database 'db_source'.
> > [Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is
> > the
> > minimum repair level for the errors found by DBCC CHECKDB (db_source
> > noindex).
> >
> > when i run query on anlyzer select * from xxx, i got the error
> > Server: Msg 823, Level 24, State 2, Line 1
> > I/O error (torn page) detected during read at offset 0x000000603f8000 in
> > file 'F:\Program Files\Microsoft SQL Server\MSSQL\data\db_Data.MDF'.
> >
> > Connection Broken
> >
> > please . thanks
> >
> >
>
>