Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > db integrity check failed
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 3rd May 02:15
jj wang
External User
 
Posts: 1
Default db integrity check failed


Hi,

I am working on sql server 2000.

I have a db maintenance job run every week to check the
integrity on all my databases including sys db: master,
msdb, and model. I started all the jobs at 12:00am every
Sunday. Will this create conflicting locks on each
integrity jobs? Because two of my database's integrity
jobs always fails. The error message indicates: 'Repair
statement not processed. Database needs to be in single
user mode.'

Any suggestions? Thanks.

JJ
  Reply With Quote


  sponsored links


2 3rd May 02:15
jasper smith
External User
 
Posts: 1
Default db integrity check failed


In the maintenance plan on the Integrity tab, uncheck the "attempt to repair
minor errors" checkbox - this option requires the db to be in single user
mode and has a habit of either not being able to get it into single user
mode or leaving it in single user mode after it's finished.Maintenance plans
actually run things serially, they just loop through the databases that the
plan is defined for and execute whatever they are set to do.

--
HTH

Jasper Smith (SQL Server MVP)

I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

Hi,

I am working on sql server 2000.

I have a db maintenance job run every week to check the
integrity on all my databases including sys db: master,
msdb, and model. I started all the jobs at 12:00am every
Sunday. Will this create conflicting locks on each
integrity jobs? Because two of my database's integrity
jobs always fails. The error message indicates: 'Repair
statement not processed. Database needs to be in single
user mode.'

Any suggestions? Thanks.

JJ
  Reply With Quote
3 3rd May 02:16
jj wang
External User
 
Posts: 1
Default db integrity check failed


Thank you so much, Jasper!!

JJ


the "attempt to repair

be in single user

into single user

finished.Maintenance plans

databases that the

do.
  Reply With Quote
Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666