I want to schedule database check. Can some check my syntax? It's probably all wrong, but at least I try :-) DBCC CHECKDB ( 'database_name' [ , {REPAIR_REBUILD} ] ) [ WITH { [ ALL_ERRORMSGS ] } ]
CHECKDB
Aug 14, 2007
3 Replies
What I am doing is scheduling a DB Check automatically once a week. To do it through Admin you have to be present. I just want to make sure the syntax is correct. I could do it trial and error, but figured I'd ask first. Craig
I want to schedule database check. Can some check my syntax? It's probably all wrong, but at least I try :-) DBCC CHECKDB ( 'database_name' [ , {REPAIR_REBUILD} ] ) [ WITH { [ ALL_ERRORMSGS ] } ]
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required