locked
Switch SharePoint 2010 server farm SQL Server RRS feed

  • Question

  • I need to upgrade our current sql server to a new high performanced server box. Could someone tell me how to switch our SharePoint 2010 server farm from current sql server to a new sql server?   

    Thanks in advance,

    Friday, August 12, 2011 12:23 PM

Answers

  • Hi,

     

    there is a TechNet article with all details on how to move databases to a new SQL server.

    http://technet.microsoft.com/en-us/library/cc512725.aspx

    Basically what you need to do is set up SQL, move all databases and set up a SQL alias on a WFE server that points to a new SQL Server.

     

    Hope it helps.


    Robi MCT Kompas Xnet d.o.o. Ljubljana, blog: http://xblogs.kompas-xnet.si, website: http://www.kompas-xnet.si, Slovenia
    • Marked as answer by peterxw Friday, August 12, 2011 8:54 PM
    Friday, August 12, 2011 1:33 PM