February 28, 2008 at 10:03 pm
Hi,
Do any of you tell me, what is Database integrity and how to create a job for Database integrity.
---
February 29, 2008 at 7:11 am
When you say database integrity, do you mean, data integrity as defined by primary keys, foreign keys, constraints, etc. or are you looking at database consistency and running the database consistency checker process, DBCC CHECKDB('dbname')?
One is about database design, the other is about proper storage and structure of the internals in the database. Please clarify which you're looking for and you'll get better answers.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 29, 2008 at 8:34 am
If you need a basic plan to check for integrity, use the Database Plan Maintenance Wizard.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply