dannytsao
asked on
xp_sqlmaint Keeps Failing
After transfer our SQL db from one sever (32 bit) Win2000 (Chinese version) to a new sever (64Bit)Win2003 (English version); also, we change the db runing from SQL2000 to SQL2005 (but still in SQL2000 mode); One of our EM job for db maintaince keep failing:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 01B66A97-87FD-4DCC-A23A-2F 18B1DCD5CB -Rpt "T:\DB_Backup\SQLLog\DBM Plan (IDSTW) TrnsLog Backup6.txt" -DelTxtRpt 1WEEKS -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpLog "T:\DB_Backup\TransLog" -DelBkUps 12HOURS -BkExt "Bak"'
output ----------------------
NULL
Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.2039
Copyright (C) Microsoft Corporation, 1995 - 1998
NULL
Logged on to SQL Server 'ATWIDS01'
as 'sa' (non-trusted)
NULL
[Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column specified is outside the range of the specified query result set.
NULL
(9 row(s) affected)
Server: Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.
-------------------------- --
Not sure why this happend and how to fix it.
Thanks for advise.
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 01B66A97-87FD-4DCC-A23A-2F
output ----------------------
NULL
Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.2039
Copyright (C) Microsoft Corporation, 1995 - 1998
NULL
Logged on to SQL Server 'ATWIDS01'
as 'sa' (non-trusted)
NULL
[Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column specified is outside the range of the specified query result set.
NULL
(9 row(s) affected)
Server: Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.
--------------------------
Not sure why this happend and how to fix it.
Thanks for advise.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.