July 28, 2008 at 6:22 am
Hi All,
I have some large DBs and have implemented Complete/Differential Backup strategy for them. Also There is a limited dba user in this server to check SQL Server Jobs status. This user is a member of db_backupoperator role in each databases and is owner of Complete/Differential Backup Job. The jobs work fine for all databases except in a replicated DB, I got the following error message:
*******************************************
Server: Msg 262, Level 14, State 1, Line 1
BACKUP DATABASE permission denied in database 'MyDB'.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
The backup set is valid.
*******************************************
Any idea will be greatly appreciated.
Sani.
July 30, 2008 at 10:38 am
Your account does not have permission to make backup. Check with your administrators.
August 3, 2008 at 1:46 am
Hi,
Thanks for the reply.
The account has proper permission as There is no problem with other DBs backup except the one which is participated in Replication. The settings in all DBs are the same.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply