Home Forums SQL Server 2005 Backups Database '' is not valid to be included in the maintenance plan. RE: Database '' is not valid to be included in the maintenance plan.

  • September 17, 2014 at 6:19 am

    #1746025

    monrroym (9/17/2014)

    Which msdb table holds the specific list of databases to be backed up for the 'backup database task'?

    None. Maint plans are SSIS packages. Follow the advice above about re-saving the plan. You should be able to toggle the list to 'all databases', save, then back to specific ones, select the ones you want and save again.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass