Thanks. So, I think I will plan for a backup/restore method.

More clearly, the primary site has node1,2,3,4. In Node 3 (SQl1,SQL1\N) and 4(SQl1\N,SQL1) has a/a pair SQL instances. Need to move only SQL1\N from WSFC 2008 to 2012....

Perry Whittle (1/29/2015)

---

All 6 nodes part of the same...

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...

Perry Whittle (1/28/2015)

---

So, you have two...

sm_iransoftware (1/27/2015)

---

Hi

I Create an availibility Group with a primary and a secondary. (For test)

Then run Planed Failover.

Switched to secondary. That's ok.

After that I update some tables on secondary (That...

Yes, Correct. Server A & B old - SQL 2012. And need to move it to server C & D new - SQL2014.

Perry Whittle (1/28/2015)

---

So if i have it correct, you have the following

ServerA and ServerB...

Yes, I have AG group in SQL 2012...

Perry Whittle (1/28/2015)

---

Simple, setup a new replica whioch is SQL Server 2014 and introduce it into your AlwaysOn group. Add the secondary database and let it synchronise.

Once synchronised you may...

Got it. It connects default port for the default instance.

I should connect listener,port 🙂

quackhandle1975 (2/25/2014)

---

Hi,

quick sanity check here: migrating from SQL 2005 to 2008 R2. I'm looking to take a full bk up on Source 2005 instance and copy/ restore to...

pmadhavapeddi22 (2/18/2014)

---

Hi,

Please suggest me what are the measures to be taken on the database or server settings if we are suggesting our client

to upgrade from SQL 2005 version to 2008...

John Mitchell-245523 (1/22/2014)

---

Interesting. Looks as if the maintenance plans...

Is the both SQL service & SQL Server Agent runs under same account.