can add sql2008 r2 instance to sql2014 cluster

Question

Viewing 8 posts - 1 through 8 (of 8 total)

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

Steve Jones - SSC Editor SSC Guru Points: 738632 More actions · Answer 1

No. You can add a database on SQL 2014 in R2 compatability mode, but not a SQL 2008 R2 instance.

The format for databases and logs has changed.

dschlobohm SSCommitted Points: 1521 More actions · Answer 2

so what they are saying is that if you run the r2 software and install it on different drives that should work

jeff.mason SSCrazy Eights Points: 9635 More actions · Answer 3

I would not install 2008 on top of 2014. You can go forward but not reverse. You risk blowing up your 2014 install if you install 2008 on top.

dschlobohm SSCommitted Points: 1521 More actions · Answer 4

this is a non critical box but the client has an app that wont work in 2014

so i offered compatibility mode but that was a turned down

I am sure that we can rebuild the 2014 if we hose it

will it work

jeff.mason SSCrazy Eights Points: 9635 More actions · Answer 5

I have never tested it to know. If you install 2008 first and then 2014, I can tell you that would work.

dschlobohm SSCommitted Points: 1521 More actions · Answer 6

so the answer is to uninstall 2014 cluster

install 2008r2 cluster

install 2014 cluster

jeff.mason SSCrazy Eights Points: 9635 More actions · Answer 7

SSCrazy Eights

Points: 9635

April 21, 2016 at 12:14 pm

That would be the safest way to do it.