none
standalone to clustered RRS feed

  • Question

  • In our environment we have sharepoint databases on standalone SQLServer 2008 R2. We are using medium farm having one WFE and one database server.We have planned to move all databases ( config, service,sos and content databases ) from stand alone server to cluster server(active\passive) for high availiblity. What will be the best approach to implement this task?also want to use the current database server for installing the clustered version instead of retiring it.

    D
    • Edited by shrawn0909 Thursday, February 2, 2012 7:52 PM
    Thursday, February 2, 2012 7:50 PM

Answers

  • There is no easy way for converting standalone SQL to cluster as you can find here http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/52b2bc03-c45e-4a54-9372-1dfa3bb98145

    You can build up your cluster and redirect your SharePoint to a new db storage. Or use the same name for clustering instance.


    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.
    Thursday, February 2, 2012 9:24 PM
  • Are you using a SQL alias?

    If you are not, then you could create one now on your SharePoint servers, using the name of your old SQL server as the name AND the target of the alias (so it isn't really doing anything)

    You can then move your DBs to the cluster, and then change the target of the alias to point to the cluster name (but SharePoint will have no problem, because it will still use the original name).

    Friday, February 3, 2012 10:11 AM

All replies

  • There is no easy way for converting standalone SQL to cluster as you can find here http://social.msdn.microsoft.com/Forums/en/sqldisasterrecovery/thread/52b2bc03-c45e-4a54-9372-1dfa3bb98145

    You can build up your cluster and redirect your SharePoint to a new db storage. Or use the same name for clustering instance.


    Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
    Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.
    Thursday, February 2, 2012 9:24 PM
  • Are you using a SQL alias?

    If you are not, then you could create one now on your SharePoint servers, using the name of your old SQL server as the name AND the target of the alias (so it isn't really doing anything)

    You can then move your DBs to the cluster, and then change the target of the alias to point to the cluster name (but SharePoint will have no problem, because it will still use the original name).

    Friday, February 3, 2012 10:11 AM