Thursday, March 22, 2012

do I have a torn page?

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, ChrisRHi
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
>|||Here's some additional info about those situations:
http://www.karaszi.com/SQLServer/in..._suspect_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...[vb
col=seagreen]
> 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
>[/vbcol]

No comments:

Post a Comment