August 27, 2008 at 6:53 pm
hello all.
am facing a problem whne trying to backup a replicated database.
details:
i have configured a replication between two databases, on the source server i have a user, i use it only for backups the use is in the db_backupoperator role in the database.
and have no permissions on the server.
when i started the backup job am getting the following error:
Msg 18799, Level 16, State 1, Procedure sp_MSrepl_backup_start, Line 17
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.
10 percent processed.
21 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
Processed 8760 pages for database 'AVSSFH', file 'New_Data' on file 1.
100 percent processed.
Processed 1 pages for database 'AVSSFH', file 'New_Log' on file 1.
Msg 18799, Level 16, State 1, Procedure sp_MSrepl_backup_complete, Line 17
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 8761 pages in 1.699 seconds (42.242 MB/sec).
---
why the hell that the procedure require that the user hows taking the backups should be sysadmin or dbowner?????????????????????????????????????????
..>>..
MobashA
August 28, 2008 at 1:30 am
Good question. A reply to a similar question here (last post).
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
August 30, 2008 at 12:18 am
there are two procedures running when i run the backup job, am considering to addjust them and see what happens.
..>>..
MobashA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply