• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2111
  • Last Modified:

SQL Consistency check

I know how I can schedule a consistency check from Enterprose Admin,  but how can I ran one on an ad-hoc basis?

0
Duncan Meyers
Asked:
Duncan Meyers
1 Solution
 
Scott PletcherSenior DBACommented:
You can issue this command:

DBCC CHECKDB ('dbName')

at anytime to check the consistency of a database.  Or, for example, create and schedule a job that has a T-SQL step with that command(s) (you could, of course, check more than one db in a step if desired:
DBCC CHECKDB('db1') DBCC CHECKDB('db2')
etc.).
0
 
Duncan MeyersAuthor Commented:
Bewdy!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now