Whitepaper : 5 Most Common Critical SQL Integrity Issues

Introduction:

The word “integrity” has multiple meanings in the SQL Server world.
One meaning deals with the quality of data stored within SQL Server.
This form of integrity is maintained through proper data typing, constraints
(default, check, unique, and key), and data validation processes. The other
definition of integrity deals with the logical and physical consistency of the
underlying structures of a database. Logical and physical consistency is the
much more complex of the two, and this is the subject we are
going to tackle in this whitepaper.

What is Integrity?

Integrity is ensuring that the logical and physical data stored in SQL
Server are structurally sound and consistent. Simply put, it means that
the data present in SQL Server should be written to it and where
it is expected to be.

SQL Server has functionality built-in for protecting the integrity of data
in SQL Server. Some of this functionality is enabled by default and some is
not. Even the integrity functionality that is enabled by default is not in use
by a lot of the systems out there. You can turn it off without realizing if you
are not careful.

Beginning with SQL Server 2005, the default page verification method is
CHECKSUM. If you create a new database, it will automatically inherit this
setting. CHECKSUM is the recommended method of page verification.
However, prior to the introduction of CHECKSUM, the default page
verification method was TORN PAGE DETECTION. If you upgrade an earlier
version of a database to SQL Server 2005 or newer, the page verification
method will not be updated. If you do not manually change this setting,
your database will not be as protected as it could be.

Topics :

Products :

Kenneth Fisher and Robert Davis

Robert L. Davis was a senior database administrator and technical lead at Microsoft. He had over 11 years of experience with SQL Server, including expertise in high availability, disaster recovery, performance tuning, and data architecture. Robert was a speaker and trainer. He was also a writer for SQL Server Magazine and co-authored “Pro SQL Server 2008 Mirroring” by Apress.

Try SQL Safe Backup FREE for 14 days



Automate SQL Server Backup Across your Enterprise

  • Backup faster and save space via dynamic compression with encryption.
  • Choose from multiple options for recovery.
  • Ensure organizational compliance via policy-based management.
  • Reduce failures due to temporary network problems.
  • Receive alerts and create reports with centralized web console.
  • Instantly read and write access to databases directly from backup files.

Start for Free