Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible to have one MOSS Farm with two Database servers?

share|improve this question
up vote 3 down vote accepted

Yes, you can use multiple SQL Server database instances to host a single farm's databases. I've seen customers who separate out content databases (collab sites, MySites) to an instance separate from the one hosting their config database, SSP databases, etc.

You can even split content databases across instances as well.

It basically comes down to specifying the proper server and instance name when creating the database.


share|improve this answer
Thanks, best regards, David – David Esteves Apr 15 '10 at 17:03

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.