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

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
>
>

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
> >
> >
>
>

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

It means that an attempt to repair the table may result in data loss, but
the only way you can try at all, is to allow for that to happen.