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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
February 29, 2008 at 8:34 am
If you need a basic plan to check for integrity, use the Database Plan Maintenance Wizard.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply