I was reading an article here about database corruption . The author says to run CHECKDB command when some suspicious activity is noticed in the database.
I do not see the logic in waiting for that activity and maybe going past it and using or creating corrupted data when it is not noticed.
Therefore, how do I automatically run CHECKDB command each time SQL starts?
This might not be the right question, so feel free to redirect the question to the right answer. I want to make certain, each time the SQL 7 starts up, that the database is not corrupted. And, if it is running constantly for a long time, how to periodically check it, automatically.
Automatically.
No .NET stuff please.
No Visual Studio stuff please.
Thank you.