locked
Sharepoint 2007 Migrate Database from SQL 32bit to 64 bit RRS feed

  • Question

  • Hi, we have a MOSS 64bit running on a 64bit OS windows 2008 and the backend database is a 32bit server windows 2003 running SQL server 2008 32bit. Now i would like to shift the databases of Sharepoint from 32bit server to 64bit (from 32bit sql to 64bit sql)

    What should be done here?


    MVI - Most Valuable Indian
    Saturday, March 26, 2011 7:20 PM

Answers

  • Hi Sheldon,

    There is a very good TechNet article to migrate database - please follow this and let us know if you have any questions.

    Thank you!


    BlueSky2010
    Sunday, March 27, 2011 3:49 AM

All replies

  • Hi Sheldon,

    There is a very good TechNet article to migrate database - please follow this and let us know if you have any questions.

    Thank you!


    BlueSky2010
    Sunday, March 27, 2011 3:49 AM
  • In addition that, there are several resources here dealing specifically with Migration. http://technet.microsoft.com/en-us/library/dd622865(office.12).aspx

    Connect with Me!

    Fabian G. Williams | Twitter @FabianWilliams | Blog http://www.sharepointfabian.com | Email: fabian@adotob.com

    Adotob Logo

    Monday, March 28, 2011 1:51 AM
  • There are 2 options Move the database to a host server that has the same name. Move the database to a host server that has a different name Which one should i choose?
    MVI - Most Valuable Indian
    Tuesday, March 29, 2011 7:10 PM
  • It should be move database to a host server with the same name. Since this is what you SharePoint config database would have unless you plan to move just the content databases to another 64 bit server.

    I would also recommened using a SQL server alias when you do this move since that would make the server name redundant for this very reason as aliases can then be pointed to any server.

    Tuesday, March 29, 2011 7:33 PM