MS SQL Server - do I have a torn page?

Author

do I have a torn page?

ChrisR

2005-04-30, 11:23 am

Ive been getting alerts like the following all morning:

DESCRIPTION: Error: 823, Severity: 24, State: 2

I/O error (bad page ID) detected during read at offset 0x0000111c264000 in
file 'D:\MSSQL\MSSQL\Data
\production_Data.mdf'.

COMMENT: (None)

JOB RUN: (None)

What do I need to do here?

TIA, ChrisR

Mike Epprecht \(SQL MVP\)

2005-04-30, 11:23 am

Hi

Look like corruption.

Run DBCC CHECKDB on the database and get last nights backup out, you might
need to restore it.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"ChrisR" <noemail@bla.com> wrote in message
news:Ow4eB1ZTFHA.2680@tk2msftngp13.phx.gbl...
> Ive been getting alerts like the following all morning:
>
> DESCRIPTION: Error: 823, Severity: 24, State: 2
>
> I/O error (bad page ID) detected during read at offset 0x0000111c264000 in
> file 'D:\MSSQL\MSSQL\Data
\production_Data.mdf'.
>
> COMMENT: (None)
>
> JOB RUN: (None)
>
>
> What do I need to do here?
>
> TIA, ChrisR
>

Tibor Karaszi

2005-04-30, 1:23 pm

Here's some additional info about those situations:
http://www.karaszi.com/SQLServer/ i...t
_db.asp

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

"ChrisR" <noemail@bla.com> wrote in message news:Ow4eB1ZTFHA.2680@tk2msftngp13.phx.gbl...
> Ive been getting alerts like the following all morning:
>
> DESCRIPTION: Error: 823, Severity: 24, State: 2
>
> I/O error (bad page ID) detected during read at offset 0x0000111c264000 in file
> 'D:\MSSQL\MSSQL\Data
\production_Data.mdf'.
>
> COMMENT: (None)
>
> JOB RUN: (None)
>
>
> What do I need to do here?
>
> TIA, ChrisR
>

Sponsored Links