xp_sqlmaint  Keeps Failing

Posted on 2007-08-07
Last Modified: 2008-01-09
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                                                                                                                                                                   ----------------------                                                                                      
Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.2039                                                                                                                                                                                                    
Copyright (C) Microsoft Corporation, 1995 - 1998                                                                                                                                                                                                              
Logged on to SQL Server 'ATWIDS01'                                                                                                                                                                                                                            
 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.                                                                                                                                      

(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.
Question by:dannytsao
    1 Comment
    LVL 8

    Accepted Solution

    most likely the maintenance plan does not exist anymore

    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

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now