• Is this production? I can understand having multiple versions in test (development) or UAT but I've never seen multiple versions in production. If only one of the databases is the real production while the others are older copies then maybe the older copies should be on another server.

    I don't use maintenance plans so the names of the databases are unimportant from a maintenace point of view. Instead I do all maintenance via stored procs executed by SQL Agent jobs. All databases get backed up daily, databases with a recovery model of FULL get transaction log backups done. etc Databases can be added, dropped with no impact on maintenance jobs

    Francis