Results 1 to 2 of 2

Thread: SQLMaint Integrity Checks failure

  1. 08-30-2005, 12:43 PM #1
    richolio
    richolio is offline Registered User
    Join Date
    Aug 2005
    Location
    san francisco
    Posts
    1

    SQLMaint Integrity Checks failure

    My SQLMaint integrity checks consistently fail when the "Repair any minor problems" option is checked. The reported reason is that the database must be in single user mode. This doesn't seem practical. Am I missing an option somewhere?
    Reply With Quote Reply With Quote
  2. 08-30-2005, 01:44 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Some type of fixes do require database to be in single user mode. To avoid it, don't fix it automatically, let it generate error and you can decide what type of fix needed and run it accordingly.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules