Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DBCC Checkdb

Status
Not open for further replies.

rinuv

IS-IT--Management
Jul 28, 2000
9
US
Hello!!!<br><br>I have a checkdb issue.&nbsp;&nbsp;Couple of our users were trying to get into one of our application and they were getting locked out.&nbsp;&nbsp;I checked the server and found out that SA had intiated a dbcc checkdb noninfomgs job.&nbsp;&nbsp;I asked around and none of us intiated that job.&nbsp;&nbsp;Could the maintenance plan we have set up intiated that job?&nbsp;&nbsp;&nbsp;What could have caused to intiate that job?<br><br>Any input is greatly appreciated!!!<br><br>
 
It may well have been the maintenance plan rebuilding indexes or checking the db consistency. Hopefully, you have your plan is scheduled to run at night to avoid clashes with users.<br>You could check the sysdbmaintplan_history tables in the msdb database to see details of what ran and when..... <p> <br><a href=mailto: > </a><br><a href= home</a><br>
 
Thanks jnicho02.&nbsp;&nbsp;<br><br>By the way, cool website!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top