Moving SharePoint (MOSS) 2007 Databases to a different SQL server
Hello All, I have reviewed many of the threads, blogs and articles on this topic, but it appears that my situation does not quite fit the scenarios being described. I inherited a small MOSS 2007 Enterprise farm (only one site collection): One SharePoint server named MOSS2007 (Win2003 32-bit and SQL 2005 installed on it) One SQL 2008 server named SQL2008 (Win2003 32-bit) My goal is to have all of the DBs reside on the SQL2008 server. Then I will uninstall SQL 2005 from the MOSS2007 server. Here is my problem: Only two DBs currently live on the SQL2008 server: (1) The content DB for the site collection, and (2) The WSS_Search DB ALL of the remaining databases are located in SQL2005 (in the MOSS2007\OFFICESERVERS instance) Thus far my research has indicated that I can move the MOSS2007 DBs to a new SQL server with a new name ONLY if the Windows and SQL versions are identical to those on the new server (not the case for me) OR if the new SQL server has the same name as the old SQL server (i.e. old SQL server is being replaced by the new SQL server - also not the case for me). The following article is where I saw these restrictions: http://technet.microsoft.com/en-us/library/cc512725(office.12).aspx#Section2 I am considering attempting an in-place upgrade to SQL2005 on the MOSS2007 server to bring my configuration inline with one of the supported scenarios. Would that work? If so, would it be the best approach? I am looking for a clear path to follow but have not yet been able to find one. All detailed suggestions are welcome. Thanks, Jeff
January 22nd, 2011 3:30am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics