0

good morning.

we currently are running on SQL server 2008 r2 and going to Sql server 2016. we are told we cannot do an in place upgrade and will have to restore all SSIS and jobs manually (script, etc) b/c cannot directly restore MSDB.

My question - can I backup the msdb, restore on a new, blank database, and then in place upgrade that msdb to SQL Server 2016....after that is complete, backup and restore that upgraded msdb back to the new 2016 instance where it belongs?

I'm not sure if this would work as I'm sure msdb contains more info than just jobs and ssis, so I'm afraid it would hose the environment.

Thoughts?

Improve this question
2
  • after reading what I wrote, it didnt make sense, lol. our 2008 r2 is being upgraded to 2016 but we are told they will not move SSIS and jobs. can I just upgrade the msdb by restoring to new instance and in place upgrading only that?
    – mes_d up
    Commented Jun 26, 2019 at 14:50
  • Please edit your question instead of adding a comment.
    – John Eisbrener
    Commented Jun 26, 2019 at 16:54

1 Answer 1

Reset to default
1

You could try, but why would you? Since you are worried about Jobs, it would be much easier to script those out. Here are a couple of methods:

MSDB does more than just hold the agent jobs, schedules, and alerts. It also has information about your backups, service broker, database mail, etc that may not be the same in your new environment.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.