How do I restore an msdb.bak from SQL Server 2008 r2 to SQL Server 2012
Posted on 2014-11-17
I have recently had to upgrade my server following a disk failure.
The new server has arrived with SQL Server 2012, but my system database backups are from SQL Server 2008 r2, so I cannot restore them! Nice one Microsoft!
The error message is:
Msg 3168, Level 16, State 1, Line 1
The backup of the system database on the device d:\MSDB3.Bak cannot be restored because it was created by a different version of the server (10.00.4067) than this server (11.00.5058).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Short of finding an old version of SQL Server 2008 r2, restoring it on that and then scripting the jobs etc out, is there a better way?
Surely Microsoft must have a work around, but I can't find it anywhere!
Thanks for you help!!!