none
Is Microsoft supporting SQL Server 2008 R2 on a Windows 2012 cluster? RRS feed

  • Question

  • Hi All,

    We have a number of applications that are using SQL server 2008 R2 standard Edition. I want to migrate the databases to a SQL server 2008 R2 cluster. Migrating the databases to SQL server 2012 is not an option. Most applications do not support SQL server 2012.

    Do I have to install SQL Server 2008 R2 on a Windows Server 2008 R2 cluster? Is it possible to install SQL Server 2008 R2 on a Windows 2012 cluster? Does Microsoft support installing SQL server 2008 R2 on a Windows server 2012 cluster? Will I be able to use some of the new functionality that Windows 2012 server offers?

    Best regards,

    Erik

    Thursday, April 11, 2013 2:10 PM

Answers

  • Hello,

    You can use Storage Spaces if you apply SP1 to SQL Server 2008 R2 on Windows Server 2012.

    However, the Resilient File System and Cluster Share Volumes are not supported by any version of SQL Server.

    The mitigation of RAM errors feature is only available on SQL Server 2012.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Marked as answer by hcv01 Friday, April 12, 2013 10:13 AM
    Thursday, April 11, 2013 3:21 PM
    Moderator

All replies

  • Hello,

    You can use Storage Spaces if you apply SP1 to SQL Server 2008 R2 on Windows Server 2012.

    However, the Resilient File System and Cluster Share Volumes are not supported by any version of SQL Server.

    The mitigation of RAM errors feature is only available on SQL Server 2012.

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com

    • Marked as answer by hcv01 Friday, April 12, 2013 10:13 AM
    Thursday, April 11, 2013 3:21 PM
    Moderator
  • Hello Alberto,

    Thanks for your reply. Now I know that it will be working fine, when I use the functionality that Windows Server 2008 R2 also provides, I am going to install SQL Server 2008 R2 on Windows server 2012.

    Regards,

    <personname ProductID="Erik Verheuvel" w:st="on">Erik Verheuvel</personname>

    Friday, April 12, 2013 10:12 AM
  • Hello,

    Thank you for visiting MSDN forums!

    Have a great day!

    Regards,

    Alberto Morillo
    SQLCoffee.com

    Friday, April 12, 2013 10:38 AM
    Moderator
  • Hi Albert 

    As per your answer it seems that SQL server 2008 r2 clusterng is supported on window server 2012 but when i have done the same thing in my lab i got the issue

    Windows Server 2003 FILESTREAM Hotfix Check      failed

    I have searched many blogs and found out the answer that for getting the above solution to work out we have to do some slip stream process.

    So i want to know without the slipstream solution is not supported.

    Wednesday, September 10, 2014 7:00 AM
  • Hi Erik,

    Mainstream support for SQL Server 2008 r2 ended this July. Only extended support is thought of informing you.


    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 Articles

    Wednesday, September 10, 2014 8:34 AM
    Moderator

  • So i want to know without the slipstream solution is not supported.

    Yes it is supported. Always raise separate thread for new question please don't post on existing thread

    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 Articles


    Wednesday, September 10, 2014 8:35 AM
    Moderator