Re: Problem with my SQL 2000 Maintenance plans.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 10/19/04 

Date: Tue, 19 Oct 2004 10:37:34 +0200

Uncheck the "attempt to repair minor problems" for your maint plan. This option is a bad idea in the
first place. If you do have a problem in the database, you want to be alerted so you can do
root-cause analysis and so on (http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp). The
option will most probably be removed in next version of SQL Server. 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Russell" <Russell@discussions.microsoft.com> wrote in message 
news:FA9647AB-08DB-4AC9-AE48-3ABD6606BF48@microsoft.com...
>I have just started a new job and am in the process of sorting out the
> database backups. On every server there seems to be the same issue with the
> integrity step. The error it is giving is when it is carrying out the 'Check
> Data and Index Linkage' the error is 'Repair Statement not processed.Database
> needs to be in single user mode.' Is there anyway around this?, or will it
> just be down to people or the replication agents being connected to the
> database at the time the integrity checking is taking place.

Relevant Pages

  • Re: Maint plan fails to backup DB or TRN, odd error
    ... I recommend removing the "repair minor problems" option from your integrity checks. ... > log to backup by turning off the step in my maint plan. ... database will need to be put in SINGLE_USER mode. ...
    (microsoft.public.sqlserver.server)
  • Re: Data integrity
    ... I do not expect 100% integrity, what I mean by that is "as ... mechanisms in the database and I have to use fingerprints ... SQL server provides guarantee against possible data damage ...
    (microsoft.public.sqlserver.security)
  • WARNING. A simple cut and paste of 8 records can distroy a SQL Server table
    ... Or delete the offending records with a Query Anaylyser delete query. ... I've being developing database applications for over 20years and the ... protect the integrity of my data. ... SQL Server does not, it would seem. ...
    (microsoft.public.sqlserver.server)
  • WARNING. A simple cut and paste of 8 records can distroy a SQL Server table
    ... Or delete the offending records with a Query Anaylyser delete query. ... I've being developing database applications for over 20years and the ... protect the integrity of my data. ... SQL Server does not, it would seem. ...
    (microsoft.public.sqlserver.programming)
  • Re: DB Integrity Check
    ... You still have a database corruption issue that you need to address. ... Microsoft SQL Server MVP ... The Maintanence Plan must put the database ... SQL Server Scheduled Job 'Integrity Checks Job for DB Maintenance Plan ...
    (microsoft.public.sqlserver.setup)