We do have two DB and two Application servers for high availability purpose .
Regarding SQL Server:
- We have full and transaction log Backup .
We created a high availability group and define the two DB servers we have.
- Under the availability group there is section for the availability replicas. Previously the main server where the full backup maintained was the primary replica, I noticed that two weeks back the replica has changed, the primary becomes a secondary. As I read about this issue, the full backup is not supported on a secondary replica unless it is configured as a copy_only. I do change the configuration of the full backup to a copy_only and I created one maintenance plane with a full backup in the primary replica which was the secondary before.
Now the issue is that:
The secondary replica (main server) is not taking the full backup even after I changed it to a copy_only, it shows below error :
This BACKUP or RESTORE command is not supported on a database mirror or secondary replica. BACKUP DATABASE is terminating abnormally. Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
The full backup on the current primary replica is not working also , it shows below error :
Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection