DB Maintenance Plan Problems

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
The jobs have all the information for executing the sqlmaint tasks; however,
they will also refer to a plan name. This is required because the msdb
maintains a plan databases table that the sqlmaint utility queries for the
list of databases to apply the plan to. Not only is it unlikely that the
same databases exist on the other server, you most certainly do not have the
plan established on the other server, just the jobs one would have
reproduced.
You would be better off using an MSX and target servers.
Sincerely,
Anthony Thomas
"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
|||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
>
>
|||In fact, I found that only the script for creating the job was scripted, I
could not found how the maintenance job itself will be scripted with the
Enterprise Manager.
Does anybody know how to generate the scripts for the Maintenance plan
itself? Or do I have to do that manually by using sp_add_maintenance_plan?
Thanks for support, rene
"AnthonyThomas" <Anthony.Thomas@.CommerceBank.com> wrote in message
news:uMS5NxB6EHA.616@.TK2MSFTNGP09.phx.gbl...
> The jobs have all the information for executing the sqlmaint tasks;
however,
> they will also refer to a plan name. This is required because the msdb
> maintains a plan databases table that the sqlmaint utility queries for the
> list of databases to apply the plan to. Not only is it unlikely that the
> same databases exist on the other server, you most certainly do not have
the
> plan established on the other server, just the jobs one would have
> reproduced.
> You would be better off using an MSX and target servers.
> Sincerely,
>
> Anthony Thomas
> --
> "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
>
|||Hi
I don't think you can script maintainance plans, the easiest way may be to
do some screen shots and re-run the wizard.
John
"Re Fo" <xrefox@.xnospamxesec.com> wrote in message
news:%232RzWXC6EHA.1264@.TK2MSFTNGP12.phx.gbl...
> In fact, I found that only the script for creating the job was scripted, I
> could not found how the maintenance job itself will be scripted with the
> Enterprise Manager.
> Does anybody know how to generate the scripts for the Maintenance plan
> itself? Or do I have to do that manually by using sp_add_maintenance_plan?
>
> Thanks for support, rene
>
> "AnthonyThomas" <Anthony.Thomas@.CommerceBank.com> wrote in message
> news:uMS5NxB6EHA.616@.TK2MSFTNGP09.phx.gbl...
> however,
> the
> Verifying
> it
> work.
> outside
> --
> --
> --
> outside
>
|||I will reiterate, if you want to deploy the same plan to multiple servers,
make one of them the Master and the rest Target servers, then you can deploy
them from one installation.
Look up Multi-Server Administration in Books Online.
Sincerely,
Anthony Thomas

"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