DB Maintenance Plan Problems

From: Re Fo (xrefox_at_xnospamxesec.com)
Date: 12/22/04 

Date: Wed, 22 Dec 2004 10:50:58 +0100

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

  • DB Maintenance Plan Problems
    ... I created a new maintenance plan with the Maintenance Plan wizard. ... Microsoft SQLMaint Utility (Unicode), Version Logged on to SQL Server ... the range of the specified query result set. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2008 backup maintenance plan requires integration services
    ... Not as comfortable as with a maintenance plan but will do the job as well... ... The SQL Server Execute Package Utility requires Integration Services to be ... To install Integration Services, run SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: SBS 2003 R2 SQL Server 2005 Maintenance Plan Doesnt WORK
    ... Maintenance Plan in SQL Server 2005. ... Microsoft CSS Online Newsgroup Support ... you may want to contact Microsoft CSS directly. ...
    (microsoft.public.windows.server.sbs)
  • RE: Maintenance Plan
    ... The best way to get sarted with Maint Wizard (or any of these admin tasks) ... Database Maintenance on SQL Server 7.0/2000 ... Troubleshooting Database Maintenance Plan Failures ...
    (microsoft.public.sqlserver.setup)
  • Re: Cannot create a Manintenance Plan in SQL Server 2005
    ... > I'm using the Maintenance Plan Wizzard to set up a Back Up Database ... Do you have SSIS (SQL Server Integration Services) Installed? ... execute maintenance plans, you must install SSIS." ...
    (microsoft.public.sqlserver.setup)
Loading