question

bmurali09 avatar image
bmurali09 asked

High availability from 2014 to 2012

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
sql server 2012sql server 2014high-availability
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

you may mirror or replicate from 2012 to 2014 but not from 2014 to 2012. Ideally, all instances involved in the topology should be the same SQL Server version
0 Likes 0 ·
You have some good answers below. This web site runs by you voting and marking the best answers. For each helpful answer below, indicate this by clicking on the thumbs up symbol next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer. This helps indicate your solution for anyone else with the same question.
0 Likes 0 ·

1 Answer

·
sjimmo avatar image
sjimmo answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.