What type of Server Roles to assign for Backup and Recovery



Hi there,

I have a question , what is the best practice to create a login to perform
backup and recovery, Can I just have DB role as DB_backupoperator or I have
to assign a sysadmin role to the user ( in SQL authentication/
windows).Coming up with a secure policy , so that when users go out from the
company it wont affect the practice.

Thanks,
Aishu
.



Relevant Pages

  • RE: Backup Errors
    ... your backup should not fail because of a disabled account. ... practice to master. ... SensePost willl be at Black Hat Vegas in July. ...
    (Security-Basics)
  • Re: theoretical question - can roots username be changed?
    ... Best practice is to use the least privilege possible to get the ... By creating users that login with super user privileges you ... Logging in directly as root leaves it open as to which user did ... spread since they would not run with super user like privileges in most cases. ...
    (Fedora)
  • RE: Backup Errors
    ... The problem the OP is describing is a quirk of Backup Exec. ... same problem when a user is disabled in exchange, ... practice to master. ... SensePost willl be at Black Hat Vegas in July. ...
    (Security-Basics)
  • Re: Exchange Best Practices analysis tool says "no backup"
    ... but err That wizard just told me that best practice was to do it. ... Is there any particular reason why not, for SBS? ... Straightforward backup from ntbackup, ...
    (microsoft.public.windows.server.sbs)
  • Re: [PHP] Redirection with header (was Re: [PHP] Cookies and sent headers)
    ... consider that 'bad practice'. ... You said that you wanted to remove login from the browser history, ... and therefore I cannot see any reason not to send a proper 303 header. ... use $_SESSION and make it such that if the user selects the log-on ...
    (php.general)