locked
Move Sharepoint WSS 3.0 to a new server RRS feed

  • Question

  • I have a Windows Server 2008 R2 box that needs to be decomissioned.  It is running WSS 3.0 SP2.  I would like to move the sharepoint site, database and all, to a Windows Server 2008 (not R2) box.  Both are using the Windows Internal Database. 

    I have already installed WSS 3.0 on the new box accepting all default options.  How can I move my stuff from the old box to the new?

    Both servers are in the same domain.

    JamesNT


    "If you have to ask about various operating system limits, you're probably doing something wrong." -Raymond Chen
    Wednesday, March 9, 2011 6:11 PM

Answers

  • AS you done with installation of new WSS and now you only need to move the content DBs and attache those to your new environment.I assume on the new server you are using the windows internal Database.

     

    There are 5 steps to move the databases to different drive:
    1. Stop all SharePoint services.
    2. Detach the databases.
    3. Move the databases files to the new location.
    4. Reattach the databases and log files.
    5. Restart the SharePoint services.

    http://technet.microsoft.com/en-us/library/dd277864%28office.12%29.aspx

     

    hope this help.

    thanks

    -ws


    SharePoint administrator, MCTS,MCITP
    • Marked as answer by JamesNT Friday, March 11, 2011 10:55 PM
    Wednesday, March 9, 2011 6:26 PM
  • I have several items in the FAQ part (III Administration) of my v3 FAQ site (see sig below).

    The one which seems to match your needs here is

    http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/DispForm.aspx?ID=134

    where you backup the databases individually; restore them to the new instance and then make changes in Central Admin.

    Check while you are there the other III.30.n items.

     

    P.S. The one thing I'm not happy about with your case is that you are going from a later version of the database system to an older version. To be quite sure this causes no problems I (myself) would first upgrade my new system to R2.

     


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    • Marked as answer by JamesNT Friday, March 11, 2011 10:55 PM
    Wednesday, March 9, 2011 6:29 PM

All replies

  • AS you done with installation of new WSS and now you only need to move the content DBs and attache those to your new environment.I assume on the new server you are using the windows internal Database.

     

    There are 5 steps to move the databases to different drive:
    1. Stop all SharePoint services.
    2. Detach the databases.
    3. Move the databases files to the new location.
    4. Reattach the databases and log files.
    5. Restart the SharePoint services.

    http://technet.microsoft.com/en-us/library/dd277864%28office.12%29.aspx

     

    hope this help.

    thanks

    -ws


    SharePoint administrator, MCTS,MCITP
    • Marked as answer by JamesNT Friday, March 11, 2011 10:55 PM
    Wednesday, March 9, 2011 6:26 PM
  • I have several items in the FAQ part (III Administration) of my v3 FAQ site (see sig below).

    The one which seems to match your needs here is

    http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/DispForm.aspx?ID=134

    where you backup the databases individually; restore them to the new instance and then make changes in Central Admin.

    Check while you are there the other III.30.n items.

     

    P.S. The one thing I'm not happy about with your case is that you are going from a later version of the database system to an older version. To be quite sure this causes no problems I (myself) would first upgrade my new system to R2.

     


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    • Marked as answer by JamesNT Friday, March 11, 2011 10:55 PM
    Wednesday, March 9, 2011 6:29 PM
  • Thank you both.  I'll give this a shot and we'll see what happens.

    Mike,

    These databases were upgraded from Sharepoint 2.0 from a SBS 2003 box so they are already from an older database version from what even is on the 2008 box.

    Even so, however, I'm not above installing SQL Server 2008 Express (upgrading the server to Windows Server 2008 R2 is not an option, unfortunatley).

    JamesNT


    "If you have to ask about various operating system limits, you're probably doing something wrong." -Raymond Chen
    Wednesday, March 9, 2011 7:17 PM
  • The R2 comment was a mistake from me. I was thinking of the database system as being R2 and the new not. Don't ask me why because I was clearly earlier aware this was the Windows Internal Database. The back OS version shouldn't make any difference.

    The earlier move from a SBS system always bothers me because of the additional functionality at least WSS 2.0 had (I have no idea about WSS 3.0 but there is still companyweb I presume which is SBS only) in a SBS 2003 system. However that's so long ago that this new problem presumably has nothing to do with that.

    Mike


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Wednesday, March 9, 2011 7:26 PM
  • I had to use STSADM -o -addcontentdb.

    1.  My content database was a different name.

    2.  I was on a later version of WSS 3.0 on the new server than the current one (I had already updgraded from WSS 2.0 from SBS 2003 some time ago).

    Otherwise, things went good.

    Thank you both!

    JamesNT


    "If you have to ask about various operating system limits, you're probably doing something wrong." -Raymond Chen
    Friday, March 11, 2011 10:56 PM
  • I'm trying to do the same moving the existing databases to a new server, did the steps above work for you, do you have other steps that you add.

    Any feedback is appreciated.

    regards,

    g

    Tuesday, November 22, 2011 7:10 AM
  • Hello,

    Here's a quick step by step guide:

    http://www.falconitservices.com/support/KB/Lists/Posts/Post.aspx?ID=50


    Miguel Fra | Falcon IT Services, Miami, FL
    www.falconitservices.com | www.falconits.com | Blog

    Thursday, December 6, 2012 9:13 PM