Page coruption

16 Mar 2006 4:40 PM

_Stephen

I am seeing errors in my db all of a sudden.

Msg 823, Level 24, State 2, Line 3

I/O error (bad page ID) detected during read at offset 0x000001d9bec000 in
file 'g:\mssql\data\ecash_prod_Data.mdf'.

or in an index rebuild I see this.

TITLE: Microsoft SQL Server Management Studio
------------------------------

Rebuild failed for Index 'Customer2'. (Microsoft.SqlServer.Smo)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Rebuild+Index&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)

------------------------------

Attempt to fetch logical page (1:631309) in database 'ecash_prod' belongs to
object 'Electracash_Account', not to object 'Customer'.
The statement has been terminated. (Microsoft SQL Server, Error: 605)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=605&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

What DBCC commands will recreate the paging properly? DBCC CheckBD or DBCC
CHECKALLOC with repair_rebuild.

Anything else?

TIA

16 Mar 2006 9:39 PM

AndyP

Do a dbcc checktable on the affected table, and also a checkalloc to check
the disk structures. You can use the REPAIR_REBUILD option with checkalloc.

On another note, check your disk space and make sure you have enough free,
and schedule some time to do a CHKDSK when convenient.

--
AndyP,
Sr. Database Administrator,
MCDBA 2003

Show quoteHide quote

"_Stephen" wrote:

> I am seeing errors in my db all of a sudden.
>
> Msg 823, Level 24, State 2, Line 3
>
> I/O error (bad page ID) detected during read at offset 0x000001d9bec000 in
> file 'g:\mssql\data\ecash_prod_Data.mdf'.
>
> or in an index rebuild I see this.
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> Rebuild failed for Index 'Customer2'. (Microsoft.SqlServer.Smo)
>
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Rebuild+Index&LinkId=20476
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
>
> Attempt to fetch logical page (1:631309) in database 'ecash_prod' belongs to
> object 'Electracash_Account', not to object 'Customer'.
> The statement has been terminated. (Microsoft SQL Server, Error: 605)
>
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=605&LinkId=20476
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>
>
>
>
> What DBCC commands will recreate the paging properly? DBCC CheckBD or DBCC
> CHECKALLOC with repair_rebuild.
>
>
>
> Anything else?
>
>
>
> TIA
>
>
>
>

17 Mar 2006 2:22 AM

Gail Erickson [MS]

Error 823 usually indicates a hardware problem. You may continue to get
these errors even after running DBCC CHECKDB, or DBCC CHECKALLOC, etc. until
the underlying problem is corrected. Make sure you check for additional
messages in the SQL Server error log and system event log that might help
you determine the root cause. Also check out your hardware, firmware
drivers, BIOS, filter drivers (such as virus software), and other I/O path
components.

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

Show quoteHide quote

"_Stephen" <sruss***@electracash.com> wrote in message
news:%23lk9XgRSGHA.5924@TK2MSFTNGP09.phx.gbl...
>I am seeing errors in my db all of a sudden.
>
> Msg 823, Level 24, State 2, Line 3
>
> I/O error (bad page ID) detected during read at offset 0x000001d9bec000 in
> file 'g:\mssql\data\ecash_prod_Data.mdf'.
>
> or in an index rebuild I see this.
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> Rebuild failed for Index 'Customer2'. (Microsoft.SqlServer.Smo)
>
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Rebuild+Index&LinkId=20476
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
>
> Attempt to fetch logical page (1:631309) in database 'ecash_prod' belongs
> to object 'Electracash_Account', not to object 'Customer'.
> The statement has been terminated. (Microsoft SQL Server, Error: 605)
>
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=605&LinkId=20476
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>
>
>
>
> What DBCC commands will recreate the paging properly? DBCC CheckBD or
> DBCC CHECKALLOC with repair_rebuild.
>
>
>
> Anything else?
>
>
>
> TIA
>
>
>