SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

SQL Server detected a logical consistency-based I/O error: Error 824, take help of trace flags and event notifications

published 646 days, 5 hours, 16 minutes ago posted by

sa 655 days, 5 hours, 50 minutes ago

SQL Server detected a logical consistency-based I/O error: Error 824, take help of trace flags and event notifications

This is a every DBA's nightmare to see if they have been alerted, yet another IO related post I would like to talk on explanation & resolution. Error 824 error indicates that a logical consistency error was detected during a read. A logical consistency error is a clear indication of actual damage and frequently indicates data corruption caused by a faulty I/O subsystem component. This is a pure indication about the hardware inconsistency within the environment with a serious I/O subsystem stability...(read more)

category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code

tags: beginner, Best Practices, DBA, dbcc checkdb, error log, extended, Monitoring, Performance, reads, recovery, search, SQL Server, torn page

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

SQL Server detected a logical consistency-based I/O error: Error 824, take help of trace flags and event notifications

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up