We are going to move an sql instance to a new physical server (SQL SERVER 2008 r2). The answer to this question explains how Agent jobs and ssis-packages will be moved by restoring the master and msdb-databases to the new server.
My question is if the order of restoring system vs user databases has anything to say? Is it OK to restore master and msdb before user databases, even though this will restore agent jobs and ssis-packages that point to user databases not yet restored/created?
Thanks for any help.
my understanding is that the order is not important... as long as the agent is not running until all db's are restored that have jobs interacting with them.
Yes, there is a dependency, but that dependency only exists upon execution of the jobs.
I would be interested in feedback subsequent to the restore of the master db.
I assume also that you are moving an existing (SQL SERVER 2008 r2) instance...
External links referenced by this document: