troubleshooting Question

HELP!!! Still testing the migration process from WSS 3.0 to SharePoint Foundation 2010.

Avatar of rsnellman
rsnellmanFlag for United States of America asked on
Microsoft SharePointMicrosoft SQL Server 2005Windows Server 2008
15 Comments3 Solutions762 ViewsLast Modified:
Hi, I am not sure if this is a problem, but here is the scenario.

I am migrating from WSS 3.0 (default install, meaning it is using SQL 2005 EE locally) on Server 2003 R2 x32 to SharePoint Foundation 2010 x64 on Server 2008 R2 with remote database SQL Server 2005 x64.

Server1: Server 2003 R2 x32 Standard Edition / WSS 3.0 default install (database content name is "WSS_Content.mdf")

Server2: Server 2008 R2 Standard Edition / SPF 2010 x64 / database content name is "SharePointFoundation2010.mdf" & resides on a remote server running Server 2008 R2 & SQL Server 2005 x64 SP4.

My question/concern is when I perform a back up of the WSS_Content (WSS 3.0) database and move it over to the new server running SQL 2005 x64 SP4 and attach it, will it need to the same name as the current database that I named during the SPF2010 Farm installation setup (SharePointFoundation2010.mdf)?  Or will I be able to restore the WSS_Content to this already existing mdf file somehow?  If I can restore it then what is the process of doing so?

If not, would I just be better off, uninstalling SharePointFoundation2010 and reinstalling it and using the default configuration name (SharePoint_Config) like the old WSS 3.0 has for it's?

Or maybe a better way to describe my concern is under SPF 2010 Web Applications section, the following:

- SharePoint - 80
- SharePoint Central Administration v4

Well, the SharePoint - 80 usually points to the "SharePoint_Config", but the Server2 configuration I installed was customized, I guess, because the SharePoint - 80 is pointing to the "SharePointFoundation2010" instead of the default "SharePoint_Config".  Will this be a problem with my migration of the database content (WSS_Content.mdf)?

Hopefully I am making sense, because I am not sure if I understand it myself.  LOL

Thanks in advance.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 15 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros