locked
SQL server requirement for sharepoint 2013 RRS feed

  • Question

  • Hello All,

    currently i have installed SharePoint2013 in server farm mode, and i have used SQL Server 2008 R2 for DB. Can i use SQL Server 2012 for SharePoint 2013?


    Thanks

    Tuesday, April 7, 2015 9:53 AM

Answers

  • Hi.

    Yes, you can use SQL Server 2012 for SharePoint 2013. The full hardware and software requirements are outlined here:

    https://technet.microsoft.com/en-GB/library/cc262485.aspx?f=255&MSPPError=-2147217396

    • Marked as answer by star.wars Friday, May 8, 2015 9:26 AM
    Tuesday, April 7, 2015 9:57 AM
  • SharePoint 2013 is compatible with SQL 2008 R2 and SQL 2012 so yes.

    What you can do is "move" the SharePoint DBs from SQL 2008 R2 to SQL 2012 without restore or backup.

    Link to msdn: https://technet.microsoft.com/en-us/library/cc512725(v=office.15).aspx

    Here you have an example for SharePoint 2010 (is the same for SharePoint 2013): http://www.codeproject.com/Articles/664029/Migrate-SharePoint-s-SQL-Server-to-another-SQL-Ser

    Here an different example: http://surya20p.blogspot.com.es/2013/09/migrate-sql-2008r2-sp2-to-sql-2012-sp1.html

    Best regards.




    Tuesday, April 7, 2015 10:57 AM

All replies

  • Hi.

    Yes, you can use SQL Server 2012 for SharePoint 2013. The full hardware and software requirements are outlined here:

    https://technet.microsoft.com/en-GB/library/cc262485.aspx?f=255&MSPPError=-2147217396

    • Marked as answer by star.wars Friday, May 8, 2015 9:26 AM
    Tuesday, April 7, 2015 9:57 AM
  • HI,

    thank you very much for quick reply, can i restore backup from SP 2013 with sql 2008 r2 as DB into SP 2013 with sql 2012 as db?


    Thanks

    Tuesday, April 7, 2015 9:59 AM
  • SharePoint 2013 is compatible with SQL 2008 R2 and SQL 2012 so yes.

    What you can do is "move" the SharePoint DBs from SQL 2008 R2 to SQL 2012 without restore or backup.

    Link to msdn: https://technet.microsoft.com/en-us/library/cc512725(v=office.15).aspx

    Here you have an example for SharePoint 2010 (is the same for SharePoint 2013): http://www.codeproject.com/Articles/664029/Migrate-SharePoint-s-SQL-Server-to-another-SQL-Ser

    Here an different example: http://surya20p.blogspot.com.es/2013/09/migrate-sql-2008r2-sp2-to-sql-2012-sp1.html

    Best regards.




    Tuesday, April 7, 2015 10:57 AM