none
How to upgrade sharepoint 2013 to 2016 using same SQL server\Instance RRS feed

  • Question

  • Hi,

    We are having SharePoint 2013 Farm installed on a Shared  SQL server data base currently, as two tier architecture.

    We want to migrate SharePoint 2013 to 2016 version using the Same existing SQL server instance. What are the steps,need to be followed for this.


    Thanks & Regards, Krishna

    Sunday, May 19, 2019 12:08 PM

Answers

All replies

  • You can do this in one of two ways:

    Backup and restore your databases under new names so you can have them mounted on both versions (just in case you have to roll back).

    Dismount your databases from 2013 and mount them to 2016 to perform the upgrade.

    I'd recommend the former.

    Just make sure you're running SQL Server 2014 w/ SP3. That is the only version supported by both 2013 and 2016.


    Trevor Seward

    Office Servers and Services MVP



    Author, Deploying SharePoint 2016

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    • Proposed as answer by Michael Han6 Monday, May 20, 2019 5:27 AM
    Sunday, May 19, 2019 2:22 PM
    Moderator
  • Hi Krishna,

    As Trevor recommended, you could backup and restore your database. To backup and restore databases, you could refer to the following articles:

    https://docs.microsoft.com/en-us/sharepoint/administration/back-up-a-content-database

    https://docs.microsoft.com/en-us/sharepoint/administration/restore-a-content-database

    Best Regards,

    Michael Han


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    • Marked as answer by krishna_2012 Monday, May 27, 2019 6:48 AM
    Monday, May 20, 2019 5:31 AM
  • Hi,

    Will there be a problem,If we install new SharePoint 2016 farm pointing to the existing SQL server\instance which is used for SharePoint 2013.


    Thanks & Regards, Krishna

    Monday, May 20, 2019 5:34 AM
  • Hi Krishna,

    I have done this before without any issue.

    Best Regards,

    Michael Han


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    Monday, May 20, 2019 5:43 AM
  • Hi Krishna,

    Is there anything to update? 

    Please remember to mark the reply as an answer if it helps. 

    Have a nice day!

    Best Regards, 

    Michael Han 


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    SharePoint Server 2019 has been released, you can click here to download it.
    Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

    Monday, May 27, 2019 6:39 AM
  • Hi Michael,

    Wanted to try with the new SQL server and New SharePoint instance if possible which is recommended by MS.

    Just To avoid down time for users during our migration.


    Thanks & Regards, Krishna

    Monday, May 27, 2019 6:49 AM