Re: DB Maintenance Plan Problems

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 12/22/04 

Date: Wed, 22 Dec 2004 11:53:45 -0000

Hi

Searching google several others have had a similar problem. Can you see the
properties of the plan and re-save it? (You may want to let the plan create
the jobs)

http://tinyurl.com/5ao8z
http://tinyurl.com/478lp

John

"Re Fo" <xrefox@xnospamxesec.com> wrote in message
news:OnTQhuA6EHA.3416@TK2MSFTNGP09.phx.gbl...
> Hi NG,
>
> I created a new maintenance plan with the Maintenance Plan wizard.
> Verifying
> this maintenance plan showed me that it was ok and executed successfully.
> Then I generated the scripts for this maintenance plan and tried to apply
> it
> to another SQL-Server. The job was created but executing seems not to
> work.
>
> I get the following errors:
>
> File 1:
> ====
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'WSZG338' as 'NT AUTHORITY\SYSTEM' (trusted)
> [Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column specified is
> outside
> the range of the specified query result set.
>
> File 2:
> ====
>
> Job 'UST-Maintenance-Plan' : Step 1, 'Maintenance Plan' : Began Executing
> 2004-12-22 10:45:00
>
> Output of sqlmaint.exe
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> ----------------------------------------------------------------------------
> ---------------------------
> (null)
> Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.194
> Copyright (C) Microsoft Corporation, 1995 - 1998
> (null)
> Logged on to SQL Server 'WSZG338' as 'NT AUTHORITY\SYSTEM' (trusted)
> [Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column specified is
> outside
> the range of the specified query result set.
> Msg 22029, Sev 16: sqlmaint.exe failed. [SQLSTATE 42000]
>
>
> Any suggestions?
>
> Thanks for support, rene
>
>
>

Relevant Pages

  • Re: DB Maintenance Plan seems corrupted
    ... parsing the strings in the scheduled jobs to determine how to display the ... reasons why I recommend creating your own jobs and dumping the wizard. ... > The maintenance plan looks corrupted although the ...
    (microsoft.public.sqlserver.server)
  • Re: Maintenance plan problems on new setup
    ... SSIS is installed and does work, so it must be something else. ... I add a maintenance plan and save it. ... The jobs fail if run from agent. ...
    (microsoft.public.sqlserver.setup)
  • RE: SQL 2005 scheduled Maintenance Plan causes a Security notification
    ... The owner of the maintenance plan was ... nor was it listed in the logs as to what account could not log on. ... I have a Maintenance Plan that runs every 30 minutes, ...
    (microsoft.public.sqlserver.server)
  • Re: Error 22029 on Maintenance Plan
    ... Check the MP and you should find a checkbox that tells the plan to "Repair ... Andrew J. Kelly SQL MVP ... > databases and does not do log backups. ... > on maintenance plan 2, just on maintenance plan 1, and it affects only two ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2005 Maintenance Plan Fails Everytime.
    ... maintenance plan using the wizard to backup the databases. ... The Maintenance Plan Wizard has a Define Maintenance Cleanup Task ...
    (microsoft.public.sqlserver.tools)
Loading