Sharepoint 2010 - 2 FARMS FROM 1 SQL SERVER

dawnDBA
dawnDBA used Ask the Experts™
on
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?

Thanks,
Dawn
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Awesome. Technically you can do this but it is not recommended at all. MS recommendation is to use separate sql instance for each farm.
There can be many reason for sites not showing up . Make sure the drives you are trying to restore on have enough space.

I agree I don’t think there will be any conflict in data base name because of that long guid .  
you should atleast create a new instance and try there

Author

Commented:
Thanks!

I understand this is not a best practice, and should clarify that it will be temporary.  The old databases will be detached and removed once the new farm is stable.  

You mention that "There can be many reason for sites not showing up" can you give me a few ideas?  I'm out of ideas... I'll also clarify that Sharepoint is not giving me any error messages, it allows me to attach the content database, and if I query the db in SMS I see that the webs table does include the correct sites.  But for some reason CA is showing me 0 site collections.

Commented:
When you go to view all site collections it does not show any thing on the right like db name owner name if that's the case. U need to attach db again.
Check for the site collection administrator.
What about free disk space hope u have enough.  
 
 
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Author

Commented:
I don't understand how free space could be related?  I was able to restore the database to the instance successfully already.  If I didn't have freespace it would have failed.  

When I say zero site collections I mean CA>Application Management> Manage Content Databases.  Here I see the name of my new content database, but under "Number of Current Site Collections" it says 0, and it should say 1.
Commented:
I had issue while restoring data bases from one server to other and after adding additional hard drive with more space i was able to restore , but may  its different in your case

it seems like corrupted back up even it shows sites in web table  . i will try to deattach this data base and use Recover data from an unattended content data base option to see if there is any thing exist in the data base or not . and then try to use stasadm,exe -o addcontentdatabase

Author

Commented:
I finally figured out the problem, looks like it was just an oversight on my part.  Both of the 2 backups that I had tried contained root site collections, and the web application I was trying to attach to already has a root.  The problem is solved now.

Thanks for your help!
Dawn

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial