backup permissions #662
Unanswered
BPPrpedreschi
asked this question in
Questions & Answers
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
hello to all
is there any way to avoid this error without putting sysadmin to the backup user?
Msg 18799, Level 16, State 1, Procedure sys.sp_MSrepl_backup_start, Line 17 [Batch Start Line 0]
Only users who are members of the following roles can perform this operation: sysadmin fixed server role; dbowner or dbcreator fixed database role in the current database.
Processed 56664 pages for database 'mydatabase', file 'mydatabase' on file 1.
Processed 0 pages for database 'mydatabase', file 'XTP' on file 1.
Processed 95 pages for database 'mydatabase', file 'mydatabase_log' on file 1.
Msg 18799, Level 16, State 1, Procedure sys.sp_MSrepl_backup_complete, Line 17 [Batch Start Line 0]
Only users who are members of the following roles can perform this operation: sysadmin fixed server role; dbowner or dbcreator fixed database role in the current database.
BACKUP DATABASE successfully processed 56759 pages in 1.981 seconds (223.841 MB/sec).
the databases have transactional replication
Regarads
Beta Was this translation helpful? Give feedback.
All reactions