The operation cannot be performed on database
"WSS_UsageApplication .
Issue: The operation cannot be performed on
database "WSS_UsageApplication" because it is involved in a database
mirroring session or an availability group. Some operations are not allowed on
a database that is participating in a database mirroring session or in an
availability group. ALTER DATABASE Statement failed.
Description: The issue occurrers when we install the
CU for SharePoint 2013 and runs the PSconfig.PSCONFIG failed with an error.
When we check the Upgrade log we see the error” The operation cannot be
performed on database "WSS_UsageApplication"
Solution: As In my environment we put the WSS_UsageApplication
under high availability. Once, I removed it from the high availability group
and run the PSconfig it worked successfully.
Ensure to remove
“WSS_UsageApplication” from the availability group before applying a CU and add
it when the upgraded is completed if necessary.
Ensure to
remove “WSS_UsageApplication” under high availability from the Primary node
only.
I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.
Thanks Anil! You saved my day!
ReplyDelete