locked
Can we run Multiple instance on SQL Server for MOSS? RRS feed

  • Question

  • As SharePoint Limitation of Database SQL Instance up to 3 TB.
    So, can we run MOSS on multiple instances of SQL Server? Because our MOSS instance on SQL is near to 3 TB.

    Thanks in advance.
    • Edited by AishaEME Wednesday, July 1, 2009 5:08 AM
    Wednesday, July 1, 2009 5:08 AM

Answers

  • Hello Aisha,

    wow 300GB per Content DB is too much. Microsoft recomment you to only store 100GB per Web Application.
    Do you know that one Web Application  is able to have more than one Content database?

    To your question...
    It should be no Problem to move your Content databases to diffrent SQL instances or Servers... stsadm -o addcontentdb should be able to attach the Databases to Web Applications from diffrent SQL instances and servers.

    Greetings,
    Andreas

    Wednesday, July 1, 2009 2:13 PM

All replies

  • AisheEME

    You canuse multiple SQL server instances for SharePoint content databases. The only restriction you need to be aware of is that the Config DB and the Admin Content DB need to reside on the same SQL instance. Everything else is fair game although it is often suggested as good practice to host the three SSP Databases on the same instance too.
    MSFT - SharePoint PFE
    Wednesday, July 1, 2009 5:19 AM
  • Dear Neil,
    Thanks for reply.

    But have only one Config Db in one Farm.
    "In our scenario there is single Farm.....why we are doing this due to reason our Web Application DB size is more than 300 GB. and we have 9 Web Apps."

    So, we need to run 3 Web Apps per Instance.

    Is it possible or not? Any suggestion welcome.
    Wednesday, July 1, 2009 5:35 AM
  • Hello Aisha,

    wow 300GB per Content DB is too much. Microsoft recomment you to only store 100GB per Web Application.
    Do you know that one Web Application  is able to have more than one Content database?

    To your question...
    It should be no Problem to move your Content databases to diffrent SQL instances or Servers... stsadm -o addcontentdb should be able to attach the Databases to Web Applications from diffrent SQL instances and servers.

    Greetings,
    Andreas

    Wednesday, July 1, 2009 2:13 PM