none
Migration from single server to two node cluster without downtime possible?

    Question

  • Hi,

    Is it possible to do migration from a single SQL Server 2012 to two node Fail Over Cluster without any downtime? Application is SharePoint.

    Or this activity cannot be done live and downtime will occur?

    Thursday, October 10, 2013 7:45 AM

Answers

  • Hi,

    Is it possible to do migration from a single SQL Server 2012 to two node Fail Over Cluster without any downtime? Application is SharePoint.

    Or this activity cannot be done live and downtime will occur?

    Hello,

    Yes you can do it by Side by side migration approach.

    1. Get windows box and install windows server on it.

    2. Create Windows server failover cluster

    3. Create SQl server failover clsuter

    4. Take backup of database from current standalone instance and restore it on Newly created SQL cluster instance

    5. Migrate logins and jobs using script method or SSIS or using below link

    http://support.microsoft.com/kb/918992 

    6. After all above steps are done when you will point sharpoint app to new DB it will say DB has been changed and will ask you to upgrade, which you have to do from comamnd promt .Details reg upgrade can be taken from sharepoint expert.This might require few minutes which you can say as downtime


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers




    Thursday, October 10, 2013 8:13 AM
  • Hi Frank,

    I dont have experience with Sharepoint.

    But with respect to SQL Server , with the help of mdf and ldf you can attach Database to an instance.

    But that in turn incurs downtime. You will not be able to copy the mdf and ldf of a DB when it is online serving requests.

    Thanks

    Please click the Mark as answer button and vote as helpful if this reply solves your problem



    Thursday, October 10, 2013 8:55 AM

All replies

  • Hi,

    Is it possible to do migration from a single SQL Server 2012 to two node Fail Over Cluster without any downtime? Application is SharePoint.

    Or this activity cannot be done live and downtime will occur?

    Hello,

    Yes you can do it by Side by side migration approach.

    1. Get windows box and install windows server on it.

    2. Create Windows server failover cluster

    3. Create SQl server failover clsuter

    4. Take backup of database from current standalone instance and restore it on Newly created SQL cluster instance

    5. Migrate logins and jobs using script method or SSIS or using below link

    http://support.microsoft.com/kb/918992 

    6. After all above steps are done when you will point sharpoint app to new DB it will say DB has been changed and will ask you to upgrade, which you have to do from comamnd promt .Details reg upgrade can be taken from sharepoint expert.This might require few minutes which you can say as downtime


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers




    Thursday, October 10, 2013 8:13 AM
  • Hi Frank,

    Shanky has provided the steps to be followed. Would like to add more on step#4 given by Shanky

    4. Take backup of database from current standalone instance and restore it on Newly created SQL cluster instance

    Once the backup is done from the current standalone instance, you should not allow write operation in that DBs to ensure the restored DB data is in sync as per the backup.By the time you do the restore, if changes are made in your DB in standalone instance by the application or manually ,the restored DB and the source DB are different which is not intended in any migration

    So you have to change the DB to read only since you don't want to take the DB offline which will be a downtime.

    Thanks

    Please click the Mark as answer button and vote as helpful if this reply solves your problem




    • Edited by udhayan Thursday, October 10, 2013 8:46 AM
    Thursday, October 10, 2013 8:41 AM
  • One related question.

    In SharePoint there are several databases such as:

    Content
    Config
    Search service
    BCS
    Medata

    If I simply copy MDF and LDF files of these databases to new server, attach them, and then point SharePoint to new server, will it work?

    Thursday, October 10, 2013 8:45 AM
  • Hi Frank,

    I dont have experience with Sharepoint.

    But with respect to SQL Server , with the help of mdf and ldf you can attach Database to an instance.

    But that in turn incurs downtime. You will not be able to copy the mdf and ldf of a DB when it is online serving requests.

    Thanks

    Please click the Mark as answer button and vote as helpful if this reply solves your problem



    Thursday, October 10, 2013 8:55 AM
  • One related question.

    In SharePoint there are several databases such as:

    Content
    Config
    Search service
    BCS
    Medata

    If I simply copy MDF and LDF files of these databases to new server, attach them, and then point SharePoint to new server, will it work?

    Hello ,

    First of all if SQL server is up and runnig you cannot copy its data and log files .You have to stop SQL services and then copy it, so whole point of no downtime is of no use.If you can go ahead it will work no issues. But I always prefer backup restore.

    Now suppose you backed up and restored DB( full backup and transaction log backup) or moved it by copy paste on cluster instance, when you point application it will only ask content DB to upgrade which you have to do from command promt.

    You can do upgrade activity of content DB during maintenance windows.It take generally 4-5 mins but depends on size of content db


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    • Edited by Shanky_621 Thursday, October 10, 2013 9:00 AM
    Thursday, October 10, 2013 8:59 AM