User does not have permission to perform this action
When we trying to restore a database we got below error.TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore of database 'xxxxxxx' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: User does not have permission to perform this action. (Microsoft.SqlServer.SmoExtended)
Cause:
No active connection on that database even though got same error finally we identified the reason is one of the orphaned replication job
Fix:
We removed that orphaned replication job from SQL agent, after that we are able to complete the restoration.
No comments:
Post a Comment