restore 2005 msdb to sql 2008 instance

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Geoff A SSChampion Points: 11511 More actions · Answer 1

i do not think it is possible. i know there are some new SPOC in msdb in 2008 that would go missing if you could restore it from 2005.

you will have to use the 'export' feature of SSIS.

george sibbald SSC Guru Points: 104210 More actions · Answer 2

I can confirm it is not possible

---------------------------------------------------------------------

crazy4sql SSCoach Points: 19590 More actions · Answer 3

what if you try with dettach and attach?

----------
Ashish

george sibbald SSC Guru Points: 104210 More actions · Answer 4

same result

---------------------------------------------------------------------

Chris Golla Ten Centuries Points: 1171 More actions · Answer 5

that's what i thought, thanks for confirming that for me.