I have a Backup DB task setup to do a full backup of All User Databases. However, I find that when new databases are added, they do not get automatically included in the backup plan.
I am forced to open the plan each time a new database is added and select All User Databases Radio button and save the package for the new DB to be added to the backup task.
Also the New DB does not show up in the SelectedDatabases collection in the properties for the backup task.
Any ideas?
Thanks, Raj