Data Replication

  • I have 2 SQL 2012 Cluster setup and configured.  

    the Legacy Cluster has all of the databases in place and running. 

    At some point I need to restore the databases from the legacy cluster to the new cluster but given the size of the databases this could take some time. 

    I was thinking I could do some sort of TLOG shipping or something to ensure that the new cluster data is kept upto date and then i can just cut over. 

    I have never done this between 2 x clusters is it possible?  is there an alternative to TLOG shipping (I dont want to use 3rd party apps).

  • Legacy on 2012 or earlier?

    I'm not sure you can get the database moved without some sort of backup/restore. Log shipping is just an elongated backup/restore, but since you can keep restoring logs, you can shorten the time.

    Don't think 2012 can have an AG span two clusters, but not sure. If so, that's a more "real time" log shipping.

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

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