locked
SQL 2008 R2 sp3 and SQL 2008 sp4 , which one is newer RRS feed

  • Question

  • I just found there is version SQL 2008 R2 sp3 and SQL 2008 sp4 , but no SQL 2008 R2 sp4 , I think the newer one should be better to use , right ?

    May I know which one of version should be used ?

    thanks

    Wednesday, December 11, 2019 4:06 AM

All replies

  • For a new install...neither, since both are out of support.

    If you are patching a server you either have SQL 2008 or SQL 2008R2...each is different and has its own SP/Cu numbers

    https://sqlserverbuilds.blogspot.com/


    22 years of database experience, most with SQL Server. Please 'Mark as answered' those posts that helped you.


    • Edited by KevinBHill Wednesday, December 11, 2019 2:31 PM
    Wednesday, December 11, 2019 4:29 AM
  • I just found there is version SQL 2008 R2 sp3 and SQL 2008 sp4 , but no SQL 2008 R2 sp4 , I think the newer one should be better to use , right ?

    May I know which one of version should be used ?

    thanks

    None of the above because all the above are not supported at all. If you "anyhow" have to use it you MUST use SQL Server 2008 R2 Sp3 but host this VM in azure cloud to get support ( this is recommended if you have to use 2008 r2 and want support as well). There is no SP4 released for SQL Server 2008 r2.

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP


    Wednesday, December 11, 2019 4:43 AM
  • Hi patrick,

    SQL Server 2008 R2 sp3 and SQL Server 2008 sp4 both are the latest SP, and they were released in September 2014. No SQL 2008 R2 sp4. About Microsoft SQL Server Versions, you can refer to this article.

    If you need to install SQL Server, I recommend using a newer version of SQL Server.

    If you have to install SQL Server 2008, please refer to this article for differences between SQL Server 2008 and 2008r2.

    Best regards,
    Cris


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, December 12, 2019 6:59 AM