Ozzmodiar (1/28/2015)
Perry's solution is a good one, but there are a few variables that need to be addressed for it to work:Is the database you're migrating the only one in the AG?
Does the 2012 server instance host other AG's that need to remain active during the migration?
Is the database you are moving set up with a DNS listener?
Yes, it has only one AG. But it's a 6 node WSFC. Node 3 & 4 has 2 pair SQL instances Default+ named. Plan is to migrate the named instances pair.
Yes, I need the same Listener and planning to create a DNS entry (Forward look up zone).
Thank you both of you. But, I am still thinking backup/restore will be a easiest one than cross cluster migration, Detach/attach & SAN migration.
Let me know your thought on this and other options.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/