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


  • Hi,


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


    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