GilaMonster (5/14/2013)
It is possible to have the mirror a higher version, but as I said it's a stupid thing to do and iirc it takes extra work to even set up that way, you can't use the GUI to set it up.
Gail,
I don't think it's so stupid, I think it depends.
I "migrated" a huge, very big database, from SQL 2005 to SQL 2008 using mirroring. It took just few seconds of downtime, literally speaking and was just changing the code. It went very well.
Backup and restore was not an option to me, too much downtime.
Of course, I knew going back was not an option, but that was actually part of the initial plan.