Has anybody encountered this error? im trying to execute
this on the QAnalyser and there's an existing database
maintenance plan setup on the server which this statement
calls.

Query:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 332C8179-42B2-
450A-8A82-2802FCDBFF6B -Rpt "D:\MSSQL7\LOG\VibesMedia
Maintenance Plan4.txt" -VrfyBackup -BkUpMedia DISK -
BkUpDB "D:\Database Backups" -BkExt "BAK"'


Results:
Output of sqlmaint.exe

Microsoft (R) SQLMaint Utility (Unicode), Version 7.00.961
Copyright (C) Microsoft Corporation, 1995 - 1998

Logged on to SQL Server 'GQ' as 'sa' (non-trusted)
[Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column
specified is outside the range of the specified query
result set.

Server: Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.


---------------------------------
all paths are existing and as you can see, 'sa' was able
to logon successfully.

any ideas or suggestions are highly appreciated...

Report this post to a moderator

Dear Jvince,

Please uncheck the option to limit the rows within the
sysdbmaintplan_history and see if this issue occurs again.
Double-click the problematic maintenance-plan. Click tab 'Reporting' and
uncheck 'Limit rows in the table to'.


Sincerely,

Eric Yang [MS]
Microsoft Support


Please do not send email directly to this alias. This is our online
account name for newsgroup participation only.
This posting is provided 'AS IS' with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security

Report this post to a moderator

yah, unfortunately, it didnt work either.

but, i just found out that the planID is not correct so I
got the correct plan ID for that maintenance , changed it
whoa! it worked! retaining all the other parameters of
course.

thanks for the help anyway...

>-----Original Message-----
>Dear Jvince,
>
>Please uncheck the option to limit the rows within the
>sysdbmaintplan_history and see if this issue occurs again.
>Double-click the problematic maintenance-plan. Click
tab 'Reporting' and
>uncheck 'Limit rows in the table to'.
>
>
>Sincerely,
>
>Eric Yang [MS]
>Microsoft Support
>
>
>Please do not send email directly to this alias. This is
our online
>account name for newsgroup participation only.
>This posting is provided 'AS IS' with no warranties, and
confers no rights.
>Get Secure! - www.microsoft.com/security
>
>
>
>.
>

Report this post to a moderator