automating process of database integrity checks

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

automating process of database integrity checks

Author

Topic

satishk
Starting Member

39 Posts

Posted - 2007-02-01 : 02:49:35

Hi,
I want to automate the process of database integrity checks in sql server any suggestions how to do

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-02-01 : 12:55:53

Here's what I use:
http://weblogs.sqlteam.com/tarad/archive/2004/06/16/1606.aspx

Just setup a job that runs that stored procedure. If ever there is corruption, the job will fail. So have some process check for failed jobs and notify the appropriate personnel.

Tara Kizer

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources