SQL Server Performance

Integrity Checks not running successfully

Discussion in 'Performance Tuning for DBAs' started by sra98a, Feb 5, 2004.

  1. sra98a New Member

    I have an integrity job set up to run weekly @4:00 a.m. It has never ran successfully. I receive the message that the DB needs to be in single user mode and All users must be logged out of the DB. At one time, only sa was connect to run the job and I still received the same message. Any ideas? HELP
    sra98a, Feb 5, 2004
    #2

  2. bradmcgehee New Member

    You probably need to remove the option "Attempt to repair any minor problems". This option does not work properly and should not be used on a production database.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
    bradmcgehee, Feb 5, 2004
    #2

  3. Luis Martin Moderator

    I don't think with that option database must be in single user.
    Yes with others option via SQL Analizer.
    But if it is, please let me know.



    Luis Martin
    Moderator
    SQL-Server-Performance.com
    Luis Martin, Feb 5, 2004
    #2

Share This Page