locked
Move SQL databases to another server using SQLAlias RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    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