Engine Watch : [sql 2005] Q: How do we verify page checksum in a database to make sure I have no hardware problem?

This Blog

Syndication

RSS 2.0
Atom 1.0

Search

News

You will find things related to database engine technology and SQL Server in this blog. Wei Xiao works in the SQL Server Development Team at Microsoft. The postings here are provided "AS IS" with no warranties, and confers no rights.

other sql server blogs

Slava Oks
sql clr
sql cat

[sql 2005] Q: How do we verify page checksum in a database to make sure I have no hardware problem?

DBCC CHECKDB will do just what you want. The PHYSICAL_ONLY option is probably the fastest way to get the checksums validated.

Published Wednesday, August 24, 2005 9:39 PM by weix

Comments

No Comments

Anonymous comments are disabled

Engine Watch