troubleshooting Question

Sharepoint 2010 - 2 FARMS FROM 1 SQL SERVER

Avatar of dawnDBA
dawnDBA asked on
Microsoft SharePointMicrosoft SQL Server 2008
6 Comments1 Solution661 ViewsLast Modified:
Hello Everyone,

I am mid-way through a project.  We have decided it was necessary to rebuild our SharePoint 2010 environments.  Due to a lack of resources we decided to utilize the same SQL Server for the new environment as the old, meaning temporarily we have 2 farms running from one instance of SQL.  Everything has gone fine until now.  I've made a copy of one of the content databases from the original environment, and restored it to another filename, and am trying to attach it to the new Sharepoint farm.  It is not recognizing any of the site collections in it.  

I have verified that the 2 farms are on the exact same version.  And to make sure this is clear when I say two farms; I mean we have to completely distinct config db's running on the same instance of SQL.  So this should remove the possibility of GUID conflicts... shouldn't it?


Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
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 1 Answer and 6 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