locked
SQL Server clustering implementation for MOSS 2007 RRS feed

  • Question

  • Hi,

    Has anybody implemented the SQL server 2008 clustering for the MOSS 2007 environment. Is there any step by step procedure regarding the same? Is it possible to add a SQL server and get it into cluster mode even the MOSS database is running on the other SQL box without getting the site down?

    Tuesday, January 4, 2011 2:03 PM

Answers

  • Hi Shakti,

    I think the second solution is better. In this way, the new database server could keep a clean environment.

    Please do a copy of database, SSPs and stop all services before moving database.

    Please go to this link for more details.  (Move all databases) http://technet.microsoft.com/en-us/library/cc512725(office.12).aspx

    Hope this could help.


    Best regards. Emir
    • Proposed as answer by RuchaP Wednesday, January 12, 2011 11:02 AM
    • Marked as answer by Lily Wu Friday, January 14, 2011 5:55 AM
    Tuesday, January 11, 2011 9:45 AM

All replies

  • Hi ,

    This article will help you to configure SQL 2008 failover cluster and when you will be ready eith it , start installing SharePoint 2007

    http://technet.microsoft.com/en-us/library/ms179410.aspx


    Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/
    Tuesday, January 4, 2011 2:21 PM
  • while giving the Database server name while configuring MOSS, do we need to give the cluster name and configure accordingly?

    I have a SQL server with sharepoint configured. I was thinking of adding another SQL server as a fail over server. which of the below steps are suitable?

    1> I have to take down the sharepoint farm, remove the SQL server from the farm and then proceed with the clustering (windows and SQL) and then add the SQL cluster to the farm

    2> take two new servers, do windows clustering and the go ahead with SQL clustering. then move the databases to the SQL cluster from the SQL box which is attached to the farm. once the movement is done, we attach the SQL cluster to the farm and remove the previous SQL box.

    Let me know your thoughts on this regard.

    Regards,Shakti

    Wednesday, January 5, 2011 6:06 AM
  • Hi Shakti,

    I think the second solution is better. In this way, the new database server could keep a clean environment.

    Please do a copy of database, SSPs and stop all services before moving database.

    Please go to this link for more details.  (Move all databases) http://technet.microsoft.com/en-us/library/cc512725(office.12).aspx

    Hope this could help.


    Best regards. Emir
    • Proposed as answer by RuchaP Wednesday, January 12, 2011 11:02 AM
    • Marked as answer by Lily Wu Friday, January 14, 2011 5:55 AM
    Tuesday, January 11, 2011 9:45 AM