😉 Thank you

Thank you

😛

Thank you .

But we dont want to have FCI. We want to use Availability Group .

and Forget our plans.

-----------------------------------------------------------------------

In simple terms :

We have 2 Practical server. (server1...

But AGs are Based on Clustering.

And my main question is about Clustering structure . because in prevoius Project we failed because of clustering . And this time we have...

It is about Availability Group.

I Planed to have One availability Group for each server.

Availability group 1 : Db1 ... 4 (Between server1 And HA)

Availability group 2 : Db5 ...

is there any another advanteges for this separation ?

Thank you for this Decisive answer.

I will forget better performance

, is there any another advanteges for this separation ?

Thank you all

And Lowell

Yes , we have a main forign key between Open Transaction And the Blocked sp.

Thankyou for Your reply :

What were the specs for the VMs that you were using? ESXi – version 6

how much ram assigned? 64

how many virtual cpus?...

Thanks Perry Whittle, Really Thanks . You are great for HA :

But there are some tips that I should say :

- All of our servers are on Virtual...

Thank you

Thank you

Excellent !!!!

😛

Thank you All

I checked it with server team.

Most likely It's related to new backup server . It has a drive with 2 T.byte size.

Although they say it...

Unfortunately we were on emergent status.

then we

1- change all IP Config from Listener to Direct Primary

2- From Primary I removed that database from AG.

3- From secondary I Drop...

Yes you are right.

Thank you for your kindness.

It is complete and right;-):-P

No It's not true.

If I Group by Cartid,SHCode , I get all records in my result.

I Need sort of Group BY cartid And get max(editDate) >>> at result...