I have several old servers that I need to migrate to several new virtual servers. Migrating the data (tables, procedures etc.) is not a problem. Transferring the users, roles, groups, and the backup jobs, and other jobs may prove very manual. The servers will not go one-to-one, so simply migrating the msdb and master will not work.
What problems might be foreseen in trying to concatenate the msdb and or master dbs??? Is it even possible? If not, what might be the best solution??
Any help is greatly appreciated. :)
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.