locked
Why can I not move SharePoint 2007 databases to a newer server with a different name? RRS feed

  • Question

  • I have the content and admin databases for an Office SharePoint 2007 site running on a server. I have to move all the databases to a newer server that has a different name but the documentation at http://technet.microsoft.com/en-us/library/cc512725%28v=office.12%29.aspx implies that that cannot be done.

    The paragraph

    This is a procedure for moving all the databases in a Office SharePoint Server 2007 farm to a new database server that has a different name. The new database server must use the same version of Windows Server and SQL Server as the old database server. To move the databases to an identically named or upgraded server, use the Move all databases to an upgraded database server procedure.

    seems to imply that you can move to a differently named server or a newer server but not both. Why not?

    Thank you very much for your help!


    • Edited by Mike Walsh FIN Thursday, April 21, 2011 5:47 AM Title reduced in length with no loss
    Wednesday, April 20, 2011 6:41 PM

Answers

  • There are various alternatives as to where the databases could now be.

    I.e they could be either on the same server as the SharePoint system or on a different server to the SharePoint system.

    The most normal - especially for MOSS 2007 - is to have the database system on a separate server.

    You can look for a MS paper on this but you can also look at an old FAQ article I wrote way back quoting someone who gave details for moving the databases from one server running SQL Server to another.

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

    I also have another FAQ item you can look at

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

    (it says WSS 3.0 but probably also applies to a basic MOSS 2007 setup too)

    but I think the first is probably more suitable in your case.

    If you have another scenario - maybe on the same server; maybe using the built-in database system ... please let us know.


    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 mcjabberz Thursday, April 21, 2011 3:56 PM
    Thursday, April 21, 2011 3:01 PM

All replies

  • > seems to imply that you can move to a differently named server or a newer server but not both

    You are reading something that isn't there.

    You can move databases to a differently named; different server. There will be additional steps needed because the server's name has changed (so if moving to a new server it is helpful if the server's name is the same as the old one) but it is possible,


    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
    Thursday, April 21, 2011 5:51 AM
  • Thank you very much!

    I thought it probably was possible but I just wanted to make sure. Being sort of an accidental SharePoint admin, I didn't want to mess the system up.

    Would you happen to know of any resources or documentation for such a procedure?

    Thanks again!

    Thursday, April 21, 2011 2:43 PM
  • There are various alternatives as to where the databases could now be.

    I.e they could be either on the same server as the SharePoint system or on a different server to the SharePoint system.

    The most normal - especially for MOSS 2007 - is to have the database system on a separate server.

    You can look for a MS paper on this but you can also look at an old FAQ article I wrote way back quoting someone who gave details for moving the databases from one server running SQL Server to another.

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

    I also have another FAQ item you can look at

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

    (it says WSS 3.0 but probably also applies to a basic MOSS 2007 setup too)

    but I think the first is probably more suitable in your case.

    If you have another scenario - maybe on the same server; maybe using the built-in database system ... please let us know.


    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 mcjabberz Thursday, April 21, 2011 3:56 PM
    Thursday, April 21, 2011 3:01 PM
  • Thank you very much good sir!
    Thursday, April 21, 2011 3:56 PM