468,257 Members | 1,414 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,257 developers. It's quick & easy.

How to automatically run CHECKDB command each time SQL starts

SwissProgrammer
207 128KB
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.
Jul 22 '20 #1
0 1343

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Tahir Khan | last post: by
4 posts views Thread by Peteroid | last post: by
10 posts views Thread by arlef | last post: by
4 posts views Thread by Ashley Bryant | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.