Re: DB Maintenance Plan Problems
From: AnthonyThomas (Anthony.Thomas_at_CommerceBank.com)
Date: 12/22/04
- Next message: John Bell: "Re: DB Maintenance Plan Problems"
- Previous message: Mike: "TSQL Query Count Columns"
- In reply to: Re Fo: "DB Maintenance Plan Problems"
- Next in thread: Re Fo: "Re: DB Maintenance Plan Problems"
- Reply: Re Fo: "Re: DB Maintenance Plan Problems"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 22 Dec 2004 05:48:30 -0600
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
- Next message: John Bell: "Re: DB Maintenance Plan Problems"
- Previous message: Mike: "TSQL Query Count Columns"
- In reply to: Re Fo: "DB Maintenance Plan Problems"
- Next in thread: Re Fo: "Re: DB Maintenance Plan Problems"
- Reply: Re Fo: "Re: DB Maintenance Plan Problems"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
