Restore Permissions for Log Shipping
When the backup job for log shipping runs on the source DB, I seem to have no issues. But when the restore runs on the backup DB, I get error error 890. I setup a new user in AD and gave them sysadmin rights but I cant tell if that is enough or if the new user is even used to perform the restore.
0 · Share on Twitter