Start Free Trial

asked on

SQL 2008 and 2008 r2 support and difference

1) are sql server 2008 and sql server 2008 r 2 2 completely different products? If so what are the main differences between the 2.

2) Is SQL 2008 R2 SP1 still supported? If not what is the latest SP level, and how long has SP1 been out of support for? I appreciate there is the MS lifecycle site, but I am not to confident on this so could do with a steer on remaining support?

3) if you have a HA setup for SQL, do all your servers need to be running the same SP level for the SQL software? or can you get away with running different versions on different servers.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

Thanks carl what goes wrong or is the reasoning behind all nodes needing to be at the same sp level? What is the potential impact if they are not

There is a potential for data corruption due to potential differences in the engine between service pack levels.

SOLUTION

Anthony Perkins

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

Thanks Anthony, is there anywhereyou can see when SP1 for R2 support is up/finished?

ASKER

08/10/2013?

Anthony Perkins

To be clearer October 8, 2013 at least in the US. It is all covered here (for the US):
Microsoft Support Lifecycle