Scenario is this, prod is two two node FCI with mirroring (primary/disaster DC). This is working just fine. New hardware is coming and a version upgrade to SQL Server 2012 (from 2008 R2) in the form of two two node FCI in primary with async AG to get the data over to the second FCI. (DR is all SAN mirroring with identical boxes in DR site)
Can I take the 2008 R2 primary and log ship all my databases to the SQL Server 2012 FCI primary while it is in an AG?
If not, I can leave the AG off and just log ship to do the migration, go live and setup the AG after the fact, that's not the end of the world. Just trying to see if I can skip the this setup.
Best Answer
You can't log ship from the principal mirror to a database that's live in an AG, but to another DB you could then make an AG later. Enabling the AG feature and having other AGs has nothing to do with what you're trying to do unless I am misinterpreting.