CODEWITHSUNDEEP
sql-server
Satellite
Satellite

Reputation: 541

Does SQL Server guarantee data integrity?

Simple question: does SQL Server provide any kind of record level checksum etc to guarantee that data in = data out? Or is this something that should be implemented at the application level with CRC/MD5?

Edit 1: I'm not talking about referential integrity, data range validation, or anything else like that.

Upvotes: 0

Views: 283

Answers (1)

Lucero
Lucero

Reputation: 60190

Yes, you can configure three modes for page data integrity through the PAGE_VERIFY option.

See for instance this article about page verification options.

Upvotes: 1

Related Questions