Move SQL databases to another server using SQLAlias RRS feed

  • Question

  • Manytimes I have successfully moved all SharePoint databases from SQL server oldSQL1 to another SQL server newSQL2 using SQL Client Alias technique. Now I need to move another SharePoint instance, where all SharePoint databases are in the server "oldSQL1\Instance1:12345". New SQL server name is newSQL2. Can I follow the same technique, by creating SQL Alias name "oldSQL1\Instance1:12345", which will be pointing to newSQL2 ?

    J Justin 

    Wednesday, February 13, 2013 9:17 AM


  • Hi Justin,

    you can use the same approach to point to new SQL server.

    Marek Chmel(MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

    Wednesday, February 13, 2013 9:58 AM