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

@Sridevi kakolu,

Thanks for the reply and the referenced material . I was worked with this option for many PTO tasks, but what I am looking for is , a query...

Thank you Ant-Green. I have changed the maintenance plan and categorized the indexes rather into Rebuild and Reorganized categories depending on which side they fall on the 30% mark replacing...

Hi,

looking at other side of it, is there a way to reclaim the space on the drive after Index Rebuild ? thank you.

Thanks everyone for your advices..I did a Rebuild of only selected indexes , with a frag percent more than 30% unlike the earlier maintenance plan that had a blanket Rebuild...