Hi, Any body can advise me, how can I proceed the high availability(Replication or Mirroring) on SQL server 2014 to SQL Server 2012. If possible to do High availability, let me know the steps to proceed. Regards Murali
Avoid mirroring as it is going to go away at some point in the future. Additionally you cannot go from a higher version of SQL Server to a lower version for mirroring nor log shipping. About your only options are to upgrade the lower version of SQL to be equal to the higher version of setup replication. One key element to keep in mind for replication is that every table that is to be replicated must have a primary key on it.