locked
Sharepoint Services 3.0 RRS feed

  • Question

  • I have made a VM clone of our production Sharepoint 3.0 server and renamed the server and gave it a different IP, we also backed up the SP DB's and then restored to a different SQL Server  the reason for all this is to do some testing without interrupting production. problem now is or my question is How do I point the cloned server to the new DB Server?  Do I need to take the server off the network then run the SP config wizard and disconnect from current Farm?  Help Please

    Thanks in Advance



    • Edited by BobbyJGR Thursday, January 5, 2012 6:02 PM
    • Edited by Mike Walsh FIN Friday, January 6, 2012 1:05 PM Can anyone answer this please? removed from Title. Has no place in a title as is not a problem description
    Wednesday, January 4, 2012 6:27 PM

Answers

  • Hi Bobby,

     

    To move all the databases in a WSS farm to a new DB server, you need to follow this steps:

     

    1.     Prepare the new database server.

    2.     Stop the farm. Before you can move all the databases, you must stop the farm to ensure that no changes are made while the databases are moved.

    3.     Back up the following databases:

                 ·         Content databases

                 ·         Configuration database

                 ·         Central Administration content database

                 ·         Windows SharePoint Services Help Search database

    4.     Copy or move the database backup files to the destination database server.

    5.     Restore the databases.

    6.     Copy to the destination database server all the SQL Server logins, fixed server roles, fixed database roles, and permissions for these databases.

    7.     Redirect the farm to reference the new database server.

    8.     Restart the server that is running Central Administration to apply the changes and ensure that the services, Web sites, and application pools that are associated with Windows SharePoint Services 3.0 are started.

    For more information, please check this Technet article.

     

    Thanks.


    Pengyu Zhao

    TechNet Community Support


    • Edited by Pengyu Zhao Friday, January 6, 2012 3:11 AM format
    • Marked as answer by Pengyu Zhao Thursday, January 12, 2012 1:21 AM
    Friday, January 6, 2012 3:10 AM
  • Hi,

    Yes remove the second server from the farm. Once you are done with it then execute the config wizard in second server and choose connect to an existing farm and this time use other DB server.


    Thanks, Rahul Rashu
    • Marked as answer by BobbyJGR Friday, January 6, 2012 12:28 PM
    Friday, January 6, 2012 4:48 AM

All replies

  • Hi Bobby,

     

    To move all the databases in a WSS farm to a new DB server, you need to follow this steps:

     

    1.     Prepare the new database server.

    2.     Stop the farm. Before you can move all the databases, you must stop the farm to ensure that no changes are made while the databases are moved.

    3.     Back up the following databases:

                 ·         Content databases

                 ·         Configuration database

                 ·         Central Administration content database

                 ·         Windows SharePoint Services Help Search database

    4.     Copy or move the database backup files to the destination database server.

    5.     Restore the databases.

    6.     Copy to the destination database server all the SQL Server logins, fixed server roles, fixed database roles, and permissions for these databases.

    7.     Redirect the farm to reference the new database server.

    8.     Restart the server that is running Central Administration to apply the changes and ensure that the services, Web sites, and application pools that are associated with Windows SharePoint Services 3.0 are started.

    For more information, please check this Technet article.

     

    Thanks.


    Pengyu Zhao

    TechNet Community Support


    • Edited by Pengyu Zhao Friday, January 6, 2012 3:11 AM format
    • Marked as answer by Pengyu Zhao Thursday, January 12, 2012 1:21 AM
    Friday, January 6, 2012 3:10 AM
  • Hi,

    Yes remove the second server from the farm. Once you are done with it then execute the config wizard in second server and choose connect to an existing farm and this time use other DB server.


    Thanks, Rahul Rashu
    • Marked as answer by BobbyJGR Friday, January 6, 2012 12:28 PM
    Friday, January 6, 2012 4:48 AM
  • Thanks Rahul, that is pretty much all I wanted to know I wasn't sure if it would affect my production server, and it didn't

    Thanks


    BobbyJGR
    Friday, January 6, 2012 12:29 PM
  • Thank you for the details, I was just worried because it was a clone of production but all is well thanks.
    BobbyJGR
    Friday, January 6, 2012 12:30 PM