Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

SQL Server mirror 10.5 to 10.0 ?

Hi.  We have a newer SQL Server running v10.5 (aka "SQL Server 2008 r2"), and we are thinking of mirroring it to our old SQL Server running v10.0 (aka "SQL Server 2008") ....
Is this possible?
I've read that you can mirror from 64-bit to 32-bit and vice-versa, but haven't seen any mention of mirroring to a (slightly) different version of SQL Server.

Thanks.
0
Rob Rudloff
Asked:
Rob Rudloff
1 Solution
 
venk_rCommented:
It'll work, partially. It is not a supported config,. if the mirroring ever fails over you will not be able to fail back.

There's really little use in a HA scenario that you can't fail over to without problems. Rather don't. Principal and mirror should be the same version. Either both 2008 or both 2008 R2.

0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now