Thank you for the response and also the link.

A question still : How do we count the license if only say , one Application Server connects to the SQL server...

Well, I don't think SQL server will allow that, else the whole idea of having a cluster like combination of Log shipping  and mirroring internals , will be defeated. Best...

Thank you, but the licensing contact needs a number from me as they would just send a Quotation/PO. So if you were me , with the user devices I mentioned,do...

• This reply was modified 3 weeks, 5 days ago by Arsh.

Thats an interesting case. I would still say stats have to be updated in someway as 0.5% still is a good 5 million rows. The stats on the table can...

• This reply was modified 2 months, 2 weeks ago by Arsh.
• This reply was modified 2 months, 2 weeks ago by Arsh.

thanks everyone for the suggestions

Its working with IP and comma. thanks. but still it fails with servername and comma ? any comments .Its a default instance and the only on...

Its working with IP and comma. thanks. but still it fails with servername and comma ? any comments

Hi Friends,

Its working fine..it was the privileges issue for that account. The servers were out of the domain, and hence are not connected to the domain then the network backup...

@ant-green

I removed the AOAG from the secondary too and reconfigured afresh. Now its in sync and healthy..thanks for your experienced advises.

Hi @Ant-Green,

Yes the database is there in the AG  MV02 in the secondary (now primary, as it failed over automatically as the Database in the primary(now secondary) had entered the...

@Ant-green

When I clicked on the 'Warnings' link from the dashboard, it says the replicas are not connected.I attached the screen shot of the same.Thank you.

@Ant-Green

Where do I find the 'Always On Health extended event files' ? pls guide as I am completely new to AoAG.btw, I attached the Health state  snapshot..Also since it doesnt...

@Ant-Green

.There was an OS related system activity (patches)  by system team and they restarted the server itself , directly multiple times brutally . can I set the HADR , ON...

for reference , i have attached the comparative state of the Availability groups and also how the database in question 'CITRIX_XD_CL' shows a changed-state (of Restoring).

Thanks and Regards.

sorry the bigges table is in 9 digits, 111 million records..and over a dozen in 10s of millions.

@AG , It was running as  legacy. I just took over..I have removed 'Index Maint' from the activities..and also i m not getting any complaints on performance, suggesting , it...