Re: Maintenance Plans

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 05/18/04 

Date: Tue, 18 May 2004 15:45:56 -0400

Gary,

We ran into this also, but the Maintenance Plan will not issue the proper
SET as the note describes. The only way that I know to do it is to go ahead
and write your own script.

Sorry,
Russell Fields
"Gary Murphy" <anonymous@discussions.microsoft.com> wrote in message
news:ec0c01c43d0e$6512bda0$a101280a@phx.gbl...
> I created a SQL Server Maintenance Plan that performs sql
> backups, optimizations and integrity checks through a
> maintenance plan.
>
> The backup portion of the maintenance plan works okay.
> But the optimization and integrity checks fail with the
> following errors:
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed
> because the following SET options have incorrect
> settings: 'QUOTED_IDENTIFIER, ARITHABORT'.
>
> We are running SQL 2000 Standard Edition SP3.
>
> I saw the Microsoft Knowledge Base Article - 301292 which
> seems to be the problem. I tried setting the sp_options
> mentioned in the article at the database level but the
> problem still occurred. I really want to use a generic
> maintenance plan, I don't want to have to write jobs for
> each database I need to perform optimization or integrity
> checks on.
>
> As a side note the database that is reporting the errors
> is part of a sharepoint install.
>
> Any help would be great.
>
> Thanks.

Relevant Pages

  • Maintenance Plans
    ... I created a SQL Server Maintenance Plan that performs sql ... But the optimization and integrity checks fail with the ...
    (microsoft.public.sqlserver.server)
  • Re: Event log error message: Database log truncated: Database
    ... our maintenance plan combines both master and the User ... It also selects Transaction Log Backup option. ... Select Recovery mode Simple for master. ... Select all options (Reorganize data and index pages, check database ...
    (microsoft.public.sqlserver.server)
  • Re: Event log error message: Database log truncated: Database
    ... our maintenance plan combines both master and the User ... It also selects Transaction Log Backup option. ... back up the database as part of the maintenance plan and etc) ...
    (microsoft.public.sqlserver.server)
  • Re: Integrity checks for DB maintenance plan
    ... > I have setup a maintenance plan to run against my database. ... The integrity ...
    (microsoft.public.sqlserver.setup)
  • Re: ALTER DATABASE (optimization job)
    ... It sounds like you are using the database maintenance plan to reindex, ... Your plan to change the recovery model won't necessarily work. ... > When this night run occurs, the transaction log on my database increases to ...
    (microsoft.public.sqlserver.tools)