locked
Moving WSS 3.0 database RRS feed

  • Question

  • Hi, our SharePoint server is running WSS 3.0 (12.0.0.4518) and the database is on another server running MSSQL 2005 Standard (9.00.3042.00).  We want to combine them into a virtual server.  Version of WSS and MSSQL will be exactly the same as the original server.  What steps do we need to take?  Thanks.

    Friday, March 11, 2011 6:55 PM

Answers

  • Hi sonicfish,

    Do you want to move database to SharePoint Server?
    If yes, there are five steps you need to take:
    1. Stop the affected services.
    2. Detach the databases from WSS.
    3. Move the database files.
    4. Reattach the database.
    5. Restart the services.
    For the details of operational steps, please see this link.
    Move Windows Internal Databases to a different drive (WSS 3.0)

    If you want to move SharePoint server and database server to a new server, please try following steps:
    1. Set up the new server.
    2. Move the databases to the new server base on above steps.
    3. Shut down the old server farm.
    For details, please see these references.
    Move to another farm
    Move and migrate servers and server farms.

    Best regards,
    Emir

    • Marked as answer by Leoyi Sun Tuesday, March 22, 2011 2:46 AM
    Monday, March 14, 2011 8:21 AM
  • Hi,

    first of all move all your mdf and ldf files to the new SQL server

    then restore all those files which will create same DBs on virtual SQL server

    Install the same version of WSS and then join that server to new SQL server , which will create new configuration DB .

    If you want you can connect to the existing config DB which you have migrated from old SQL

    Then create sites and attach site content DB using following stsadm command

    stsadm -o addcontentdb -url <SITE URL> -dn <DB Name>

    HTH

     


    Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    • Marked as answer by Leoyi Sun Tuesday, March 22, 2011 2:46 AM
    Monday, March 14, 2011 8:33 AM
  • Hi sonicfish,

    Thanks for your reply.

    Yes, please follow above steps. After you copy the database to the destination database, you need to fix server roles, database roles, and permissions for these database.

    Then redirect the farm to the new database server. We recommend that you direct the farm to the new database server by using a SQL Server connection alias. You must create a SQL Server connection alias that can be used by all server(including the front-end Web servers and application servers) to connect to the instance of SQL Server. A connection alias is an alternatvie name that you can use to make a connection to an instance of SQL Server.

    Best regards,
    Emir

    • Marked as answer by Leoyi Sun Tuesday, March 22, 2011 2:46 AM
    Tuesday, March 15, 2011 6:12 AM

All replies

  • Hi sonicfish,

    Do you want to move database to SharePoint Server?
    If yes, there are five steps you need to take:
    1. Stop the affected services.
    2. Detach the databases from WSS.
    3. Move the database files.
    4. Reattach the database.
    5. Restart the services.
    For the details of operational steps, please see this link.
    Move Windows Internal Databases to a different drive (WSS 3.0)

    If you want to move SharePoint server and database server to a new server, please try following steps:
    1. Set up the new server.
    2. Move the databases to the new server base on above steps.
    3. Shut down the old server farm.
    For details, please see these references.
    Move to another farm
    Move and migrate servers and server farms.

    Best regards,
    Emir

    • Marked as answer by Leoyi Sun Tuesday, March 22, 2011 2:46 AM
    Monday, March 14, 2011 8:21 AM
  • Hi,

    first of all move all your mdf and ldf files to the new SQL server

    then restore all those files which will create same DBs on virtual SQL server

    Install the same version of WSS and then join that server to new SQL server , which will create new configuration DB .

    If you want you can connect to the existing config DB which you have migrated from old SQL

    Then create sites and attach site content DB using following stsadm command

    stsadm -o addcontentdb -url <SITE URL> -dn <DB Name>

    HTH

     


    Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    • Marked as answer by Leoyi Sun Tuesday, March 22, 2011 2:46 AM
    Monday, March 14, 2011 8:33 AM
  • Just the make it clear, the new visualized server (wss 3.0 & sql) will have different name than the original server, can I still follow the steps in your reply?  Thanks.
    Monday, March 14, 2011 11:08 PM
  • Hi sonicfish,

    Thanks for your reply.

    Yes, please follow above steps. After you copy the database to the destination database, you need to fix server roles, database roles, and permissions for these database.

    Then redirect the farm to the new database server. We recommend that you direct the farm to the new database server by using a SQL Server connection alias. You must create a SQL Server connection alias that can be used by all server(including the front-end Web servers and application servers) to connect to the instance of SQL Server. A connection alias is an alternatvie name that you can use to make a connection to an instance of SQL Server.

    Best regards,
    Emir

    • Marked as answer by Leoyi Sun Tuesday, March 22, 2011 2:46 AM
    Tuesday, March 15, 2011 6:12 AM