Log contents only have 214 rows . Majority of the operations are for LOP_MOFIFY_ROW etc . I have seen for LOP_SHRINK_NOOP.

Thanks...Arshad

It backups the other databases. I asked it not to ignore any , but still leaves out the one in the Availability Group?  thank you

@michael-2 , No its not backing the Primary Up...It ignores it (Though I unchecked the option 'Ignore Databases that are  Not Online')..I get the warming you mentioned above , but...

• This reply was modified 3 years, 9 months ago by Arsh.

@Ant-Green Yes ,  Log backups are helping to have a control on the file size. Also, I had found some default trace was running , so stopped that too...Looks fine...

@Ant-Green  Is this increase in the log-file size normal in Read-Scale ? The actual log-file size is just over 0.5 GB only. There are no drastic changes at the application...

Hi Brahmand,

Yes , its strange , given the size of the Database itself..The logfile eventually went to its fullest of 20GB...As the Drive was full, I had to move the...

• This reply was modified 3 years, 9 months ago by Arsh.
• This reply was modified 3 years, 9 months ago by Arsh.

Hi Michael,

Thanks for pointing this. I did configure them and now it works...Thank you.

Best Regards..Arshad

• This reply was modified 3 years, 10 months ago by Arsh.

I get the message "Ping Request Couldn't find Host <Listener>"...Its strange that this error is from the same server that hosts primary replica.The connections from SSMS are fine though.

Thank you....Arshad

Andreas,

The local firewalls on the servers are disabled as per the Admin. They are on AWS Cloud.I connect to the servers through VPN.

Thanks and Regards...Arshad

Hi Andreas,

Ping request (Sent from the Primary ) fails for the Listener but has replies, (even from the secondary) for the Listener IP (which also is the IP of the...

• This reply was modified 3 years, 10 months ago by Arsh.

Hi Andreas,

Thanks for kind response.

The IP of the Primary and also the secondary are on the same subnet. I connect normally to two both the instances (albeit after a fix...

Got it resolved. The Infra team helped change the name resolution settings and replaced the 'servername.domainname' notation with only the servername.Thank you.

The Infra team resolved it working at the Domain Name controller.

Hi Michael,

It throws the standard error "  Network Related or Instance-specific...."... Actually, as I noticed, the connection from outside 'Add Replica" isn't also possible with the <'Servername'>\'<InstanceName>' notation , but...

• This reply was modified 3 years, 10 months ago by Arsh.

Hi Brian,

This works on the SQL server default port though. So , clearly some ports issue at the firewall. I can now connect to both the instances from my laptop.

Thanks..Arshad