Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Cross-Farm Content Databases

  Asked By: Cesar    Date: Mar 30    Category: Sharepoint    Views: 1930

So I found out today I could add to my production farm a content
database still attached to my development farm.

1) Is this as dangerous as it sounds

2) If it is, why can you do that!

There is no better means of promoting another person's change of heart

than allowing our own heart to be changed.



3 Answers Found

Answer #1    Answered By: Baiju Hoskeri     Answered On: Mar 30

It's not that big of a deal, really. The content  database contains the managed
path for the contained sites, so it uses the web application details to provide
the full path. It just means that you would have the following sites available:



Technically you could even have this content database housed on the same farm
as long as they were in two seperate web applications. You just don't want to
try and bring up a copy of that content database on the original web
application. This would create confusion in the config database.

Answer #2    Answered By: Kristy Hicks     Answered On: Mar 30

I'm not sure about it being supported by Microsoft or not, but I know
that 1 content  database will work fine from 2 farms - as long as you
don't make any changes that are registered with the configuration
database - otherwise the farm  that you are not using will not see that
change.. One of the most apparent changes to avoid is to create a new
site within that content database, because that new site will not be
registered in the configuration database for both farms.

Answer #3    Answered By: Amanda Brown     Answered On: Mar 30

It seems to be quite a big deal that you cannot create a new site within
the dev content  database and have it appear in production. However, I
imagine that removing, and then reattaching the content database from
production would associate the new site to that farm, just as it did the
first time the database was associated.

This reveals what may be a solution for a problem I've been having for
quite some time.

I tried to provision Project Web Access on a Shared Service Provider. It
failed to provision, and then failed to unprovision. Even after
detaching the content database, and rebuilding the SSP, I still get the
error that the site /MSProject already exists.

Does that error come from the farm  config? Can I fix it manually?

Didn't find what you were looking for? Find more on Cross-Farm Content Databases Or get search suggestion and latest updates.