• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 590
  • Last Modified:

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.
0
pma111
Asked:
pma111
  • 3
  • 2
  • 2
2 Solutions
 
Carl TawnSystems and Integration DeveloperCommented:
1) No they are not completely different version. R2 has some incremental changes, mostly related to BI components rather than the core engine and parser.

2) SP1 is out of support as of November 2011. The latest SP is Service Pack 3.

3) All the nodes involved in the HA solution need to be running the same SP level.
0
 
pma111Author Commented:
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
0
 
Carl TawnSystems and Integration DeveloperCommented:
There is a potential for data corruption due to potential differences in the engine between service pack levels.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Anthony PerkinsCommented:
1.They are considered separate versions.
2. SQL Server 2008-R2 has two service packs.

See here for a complete list:
http://sqlserverbuilds.blogspot.com/
0
 
pma111Author Commented:
Thanks Anthony, is there anywhereyou can see when SP1 for R2 support is up/finished?
0
 
pma111Author Commented:
08/10/2013?
0
 
Anthony PerkinsCommented:
To be clearer October 8, 2013 at least in the US.  It is all covered here (for the US):
Microsoft Support Lifecycle
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

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