Scripting around a DBCC Checkdb

• mpeters

  SSC Rookie

  Points: 37

  More actions

  August 12, 2003 at 11:47 am

  #81653

  Not being a DBA or DBA programmer, I apologize in advance is this is a little base, but I can't seem to find the answer from the SQL Knowledgebase.

  I have been asked to automate a database integrity check from VBScript (VBScript is used to automate our current Disaster Recovery data replication - this would just be an extension to that code).

  I need to basically do the following:

  Attach a list of databases

  Run a DBCC Checkdb against them and get an overall success/fail

  Detach the databases.

  I can handle the attach/detach through SQLDMO objects, but how do I run a DBCC and get a simple Success/Fail result? Someone has suggested running the DBCC check via the SQLMAINT.EXE util - would this be a viable option?

  Thanks for any advice.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  August 12, 2003 at 11:40 pm

  #469671

  Hi mpeters,

  quote:

  ---

  I can handle the attach/detach through SQLDMO objects, but how do I run a DBCC and get a simple Success/Fail result? Someone has suggested running the DBCC check via the SQLMAINT.EXE util - would this be a viable option?

  ---

  yes, it is a viable option.

  If you don't want to deal with the command line, you can use xp_sqlmaint as explained in BOL.

  Cheers,

  Frank

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• 5409045121009-7368

  SSCoach

  Points: 15740

  More actions

  August 13, 2003 at 12:15 am

  #469677

  "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlmaint" -S lene -D Northwind -CkDB -CkCat -Rpt C:\Northwind.rpt

  if errorlevel 1 echo ERROR

  if errorlevel 0 echo OK

  "C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlmaint" -S lene -D MSDB -CkDB -CkCat -Rpt C:\MSDB.rpt

  if errorlevel 1 echo ERROR

  if errorlevel 0 echo OK

  It worked!