yes, its a re-publisher

This is not a interview Q.
I just wanted to know is Devops really needed for a DBA

I ran the command as part of the job Distribution Clean up: Distribution,owner of the job 'sa'

Enabled xp_cmdshell and XYZ has full permissions on snapshot folder.

still the job fails with same message.

Executed as user: XYZ. You do not have sufficient permission to run...

it fails in both ways.

Tracert gives me output less than 1ms.

Does anyone have a solution to this problem

They are all in the same domain

yes, for automatic failover.

I have tried stopping and starting endpoints,Issue is not resolved.

we are facing this issue once or twice in a week and the principal server databases are failing over to mirror...

thank you,

can you tell me how much max and min memory we need to set and are there any standard settings based on the RAM configuration.

can you provide detail steps...

since sqlserver is the only one running in the machine why do we need to set Max memory setting

as it can allocate memory dynamically when ever required

Iam receiving the below error

The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore...

what are the parameters we need to check before setting maxserver memory.

our server is running with 8gb,what is the suggested max memory

we are receiving continuous alerts for Highmemory usage regarding sqlserver,maxserver memory is set to 2147483647.