you're welcome

Fernando Jacinto Alvarez (1/29/2015)

---

My boss want to migrate to sql 2014 currently we have another site and he wants to create a DR using AlwaysOn AG what do you suggest...

level 7 is not published yet but you can find detail on combining an FCI into an AlwaysOn group starting at this link[/url]

check out my stairway series on this site for more info. Level 6 is due to be published soon and covers AlwaysOn Availability groups and readonly routing in detail.

Part 1...

Perry Whittle (1/25/2015)

---

Levels 1 to 4 detail the requirements for a windows server failover cluster, this forms the basis of either an FCI or an AlwaysOn Availability group setup.

Level 5...

sorry there's been so many posts here I'm lost in the myre now.

Do you want to deploy an FCI only?

If yes leave part 4 you don't need it

If a full backup has occurred on the principal since mirroring broke you're stuck with re initialising mirroring unless...

Ozzmodiar (1/29/2015)

---

Sorry Perry, I dropped the ball on terminology there. It will be multiple AG's, not listeners. I had it in my head that the groups were 1...

select SizeBytes, SizeBytes / 1024 As Megabytes

from

TESTTABLE

you don't have an FCI to integrate so skip that, the portion that shows how to create an AO group will be relevant though

So, has a full backup been taken on the principal since the mirroring broke?

Use this query against the principal and then the mirror to ascertain if it has or not

select...

an Availability group can only have one primary read\write database, The remainder are readable secondaries!

Convert it to what?

just divide it by 1024 will give whole MBs. Are...

we have one here over 8TB in size and growing

Calvin Duffy (1/27/2015)

---

The mirroring type is "High Performance (asynchronous)". There are no witness server(s). Need to write to the database (Mirroring db not the primary db). Can't do role switching....