Goal: Win 2k3 R2 SP2, SQL Server 2005 64 bit
If you are planning on migrating from 32 to 64 bit for your SQL Server ... look no further. After reading though blogs, white papers, and books ... I decided to that there was an easier way to handle all this nonsense. In simple terms:
- Backup the databases on the 32 bit DB server (let's call it SharePointDBServer)
- Take the web server offline, stop all services, sites, app pools
- Take SharePointDBServer offline
- Bring up a different 64 bit DB server with the same name as the old one (SharePointDBServer)
- Restore the backups to the 64 bit DB server.
- Reboot the web server
- Restart any services on the web server that were stopped
Keep in mind that if you have a DB server naming convention like SQL64SharePoint ... it probably won't work ... or if you cannot take the 32 bit DB offline ... that won't work either, etc, etc ...
If you have the means, this is ridiculously easier then trying this through STSADM ...
Things to remember:
- Pay attention to the Owner of the databases after they are created on the new 64 bit server ... this will most likely be domain/Administrator ... which may not be the Owner of the previous DBs.
- The services running on the new DB server will not be using the identities that were customized for the old DB server ... you will need to put in the correct user for some of those services.
4 comments:
I am doing a parallel migration of my SharePoint infrastructure from 32-bit to 64-bit. All under same AD Domain and all are new Computer name.
So what is the best approach?
Just to be clear ... when you say "infrastructure" do you mean 1 DB server and 1 web server?
Yes, one back-end SQL 2005 SP2 and one MOSS 2007 with SP1. My test MOSS 2007 that becomes a production is all-in-one. Initially the test environment becomes a production environment, so I will deploy my SharePoint Infrastructure from 32-bit to 64-bit. From one all-in-one box to two box (1DB & 1MOSS 2007) in parallel.
I would recommend (if possible) to separate and go to 32bit first. Then go to 64.
Separating and going to 64 in one step can get messy.
Here are few articles I found on my travels ... the last article is in Romanian ... use Google translate to read.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3466481&SiteID=1
http://www.eggheadcafe.com/software/aspnet/30321398/single-server-to-farm.aspx
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/MS-SharePoint/Q_23159639.html
http://itboard.ro/blogs/valys_blog/archive/2008/04/09/user-profile-migration-moss-2007.aspx
Post a Comment