dave-dj (4/26/2010)
Hi Jason,The last post dissappointingly answered a question I had. My other question though, is what process would you recommend for upgrading SQL 2005 servers that are taking part in mirroring.
I haven't had to do that yet (all of our SQL 2K8 servers are supporting new apps, and we don't have plans to upgrade our existing 2K5 servers any time soon). I would think you would want to upgrade the mirror server first if you want to have a minimal impact on mirroring. (You can mirror from 2005-2008 for awhile if you need to).
The Redneck DBA