locked
SharePoint 2010 DB moved to new SQL server RRS feed

  • Question

  • Hi All,

      Quick Question.. When we move SP 2010 DB to one SQL server to New One .. What are thing need to followed to make sure Sites are working fine 

     


    V Jean

    Friday, December 20, 2013 1:33 PM

Answers

  • Hi.  I recently followed that guide (http://technet.microsoft.com/en-us/library/cc512723(v=office.14).aspx) and it went pretty well.  Before starting, I recommend you ensure the new SQL server is prepared by ensuring:

    1. It has enough disk space to hold the database(s) and allow for growth
    2. Firewall ports are opened to allow connections from the SharePoint server
    3. The hardware meets the requirements
    4. You have RBS enabled if required
    5. You have backups!

    Dave

    • Proposed as answer by Hemendra Agrawal Tuesday, December 24, 2013 11:26 AM
    • Marked as answer by Lindali Thursday, December 26, 2013 9:31 AM
    Sunday, December 22, 2013 8:59 AM

All replies

  • 1. What DB ? Content DB ?
    2. Why moving ?

    But to answer your questions the best thing to do is to backup all the DBs first and follow this http://technet.microsoft.com/en-us/library/cc512723%28v=office.14%29.aspx


    AJ MCTS: SP 2010 Configuration MCSA: Windows 7 If you find this post useful kindly please mark it as an answer :) TY


    • Edited by itsAboutSp Friday, December 20, 2013 1:40 PM
    Friday, December 20, 2013 1:40 PM
  • Hi.  I recently followed that guide (http://technet.microsoft.com/en-us/library/cc512723(v=office.14).aspx) and it went pretty well.  Before starting, I recommend you ensure the new SQL server is prepared by ensuring:

    1. It has enough disk space to hold the database(s) and allow for growth
    2. Firewall ports are opened to allow connections from the SharePoint server
    3. The hardware meets the requirements
    4. You have RBS enabled if required
    5. You have backups!

    Dave

    • Proposed as answer by Hemendra Agrawal Tuesday, December 24, 2013 11:26 AM
    • Marked as answer by Lindali Thursday, December 26, 2013 9:31 AM
    Sunday, December 22, 2013 8:59 AM
  • Thanks All

    V Jean

    Thursday, December 26, 2013 9:36 AM