Post reply

Migrate SQL Server 2008 FCI to 2016 AlwaysOn

  • January 31, 2019 at 12:23 am

    #409472

    Hi
    We  have  SQL 2008 Failover  Cluster Instance with  10 user databases, we want to migrate from FCI to 2016 AlwaysOn cluster with DR site. so we have following concerns appreciate if someone can advice on this or share the way to do this.
    1.  is there way to upgrade from FCI to AlwaysOn (In-house upgrade) ?
    2.  What are the best practices to migrate
                      a. first create separate alwayson cluster not touching fci and migrate user databases from FCI to AlwaysOn, is this okay to do ?

    Thanks

  • January 31, 2019 at 3:02 am

    #2020679

    Hi,
    We are in the process of doing something very similar and have had to make it up as we go along.
    We have the luxury of two new physical servers to host our new AO replicas but I am sure the approach we have taken would work in any architecture.
    We installed SQL 2017 on both servers, default instance and then created an AG to span these. This required using cluster services but not a FCI.
    We then backed up out set of databases from the old server and restored to the primary replica and then added these databases in to the AG, allowing SQL to backup/restore them on the new secondary replica.
    This has all worked fine so far but you may want to consider how you get the job histories to failover, as they live in MSDB which is not part of the AG.

  • January 31, 2019 at 3:11 am

    #2020681

    Hi Wilson

    Thanks a lot for your reply.

    Hope this is a safest way to do this.

    Thanks

    Harshana

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply