[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 408
  • Last Modified:

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-2F18B1DCD5CB -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.
0
dannytsao
Asked:
dannytsao
1 Solution
 
natokaCommented:
most likely the maintenance plan does not exist anymore

run:
select * from msdb.dbo.sysdbmaintplans where plan_id='01B66A97-87FD-4DCC-A23A-2F18B1DCD5CB'

if it's empty, then you can either search for the right plan id and try, or just recreate the maintenance plan
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now