Anytime I try to backup database from my computer, it will tell me "The server principal is not able to access the database " UFC" under the current security context. BACKUP DATABASE is terminating abnormally. Q- What do I have to do in order to BACKUP DATABASE and RESTORE DATABASE
asked Jul 07 at 09:58 AM in Default
Check the permissions of the server principal mentioned in your error message, I believe they will need to have the db_backupoperator role membership within the database (assuming you need to stay at the database level). Also check the owner of the UFC database, try setting it to sa to see if that helps, sometime it can be an impersonation issue there.
answered Jul 07 at 10:56 AM