locked
restore msdb issue RRS feed

  • Question

  • We are currently using sql 2008 r2 and we migrating to sql 2012, in that how to restore the MSDB database
    Monday, November 11, 2013 10:05 AM

Answers

  • it is not advised not to try  restore msdn database of SQL Server 2008 R2 to SQL Server 2012. as msdb contains the information of jobs , please move the jobs manully instead to restoring the msdb database.

    Ramesh Babu Vavilla MCTS,MSBI

    • Proposed as answer by Alisa Tang Friday, November 15, 2013 8:30 AM
    • Marked as answer by Fanny Liu Monday, December 2, 2013 6:59 AM
    Monday, November 11, 2013 10:21 AM
  • I guess, it is not supported (or even possible) to restore a msdb to another SQL Server version. You can transfer the jobs by scripts or by SSDT. But be careful, the msdb still have informations about Alerts,  Maintenance Plans, Operators, SQL Server Agent configurations, SSIS Packages, etc. You will have to configure all this things again.
    • Proposed as answer by Alisa Tang Friday, November 15, 2013 8:30 AM
    • Marked as answer by Fanny Liu Monday, December 2, 2013 6:59 AM
    Monday, November 11, 2013 11:19 AM
  • I guess, it is not supported (or even possible) to restore a msdb to another SQL Server version. You can transfer the jobs by scripts or by SSDT. But be careful, the msdb still have informations about Alerts,  Maintenance Plans, Operators, SQL Server Agent configurations, SSIS Packages, etc. You will have to configure all this things again.
    yes it is not supported to restore msdb database on later versions of sql server

    Ramesh Babu Vavilla MCTS,MSBI

    • Proposed as answer by Alisa Tang Friday, November 15, 2013 8:30 AM
    • Marked as answer by Fanny Liu Monday, December 2, 2013 6:59 AM
    Monday, November 11, 2013 11:22 AM
    • Proposed as answer by Alisa Tang Friday, November 15, 2013 8:30 AM
    • Marked as answer by Fanny Liu Monday, December 2, 2013 6:59 AM
    Monday, November 11, 2013 11:23 AM

All replies

  • it is not advised not to try  restore msdn database of SQL Server 2008 R2 to SQL Server 2012. as msdb contains the information of jobs , please move the jobs manully instead to restoring the msdb database.

    Ramesh Babu Vavilla MCTS,MSBI

    • Proposed as answer by Alisa Tang Friday, November 15, 2013 8:30 AM
    • Marked as answer by Fanny Liu Monday, December 2, 2013 6:59 AM
    Monday, November 11, 2013 10:21 AM
  • I guess, it is not supported (or even possible) to restore a msdb to another SQL Server version. You can transfer the jobs by scripts or by SSDT. But be careful, the msdb still have informations about Alerts,  Maintenance Plans, Operators, SQL Server Agent configurations, SSIS Packages, etc. You will have to configure all this things again.
    • Proposed as answer by Alisa Tang Friday, November 15, 2013 8:30 AM
    • Marked as answer by Fanny Liu Monday, December 2, 2013 6:59 AM
    Monday, November 11, 2013 11:19 AM
  • I guess, it is not supported (or even possible) to restore a msdb to another SQL Server version. You can transfer the jobs by scripts or by SSDT. But be careful, the msdb still have informations about Alerts,  Maintenance Plans, Operators, SQL Server Agent configurations, SSIS Packages, etc. You will have to configure all this things again.
    yes it is not supported to restore msdb database on later versions of sql server

    Ramesh Babu Vavilla MCTS,MSBI

    • Proposed as answer by Alisa Tang Friday, November 15, 2013 8:30 AM
    • Marked as answer by Fanny Liu Monday, December 2, 2013 6:59 AM
    Monday, November 11, 2013 11:22 AM
    • Proposed as answer by Alisa Tang Friday, November 15, 2013 8:30 AM
    • Marked as answer by Fanny Liu Monday, December 2, 2013 6:59 AM
    Monday, November 11, 2013 11:23 AM