December 30, 2010 at 12:38 am
I would like to create a maintenance plan on SQL 2005 for DB backup, user (bkoper) has been created for backup with database role db_backupoperator granted, when I login with bkoper, I found that bkoper can not trigger the backup job as there is no "SQL Server Agent" on Management Studio "Object Explorer", and so he can not trigger the backup job with "SQL Server Agent" -> Jobs -> DB backup job, is there any additional authority I need to grant so that he can trigger the backup job? thx.
December 30, 2010 at 12:52 am
Yes, the account needs msdb access roles as well, SQLAgentOperatorRole.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 30, 2010 at 2:21 am
Bekker,
It works, thank you very much for your help, thx.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply