Re: What type of Server Roles to assign for Backup and Recovery

Any member of db_backupoperator can perform backups on the same database.
Members of the fixed server role, dbcreator, can create databases. Just add
and remove logins from these roles as required.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Aishu" <Aishu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5C2A13C5-9B9A-421A-9295-73252B3C642F@xxxxxxxxxxxxxxxx
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

  • Extracting logins from a master database
    ... I installed SQL Server and created a database, logins etc. ... I have backups of the ...
    (microsoft.public.sqlserver.security)
  • Re: Database Size, Database Corruption, Message Store & Storage Group
    ... More careful monitoring of the server. ... Each extra storage group also requires more memory at startup, ... Also it is important to know if there was actually database corruption. ... In terms of backups, you should look at "how" you are performing backups. ...
    (microsoft.public.exchange.admin)
  • Re: Advice Requested : Disaster Recovery with 2 Drives (No Raid) with SQL Server 2008
    ... so we need frequent copies of the database for testing, ... Andrew J. Kelly SQL MVP ... But by placing the backups on the same drive as the data or logs you risk loosing data if one of the drives crashes since you will loose backups and either the log or data files. ...
    (microsoft.public.sqlserver.programming)
  • Re: Logging in irrespective of database access
    ... Try connecting using Query Analyzer with one of the problem logins and run ... the following in the context of your demodata and accounts databases: ... This will return the security context used to access the database. ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... Try connecting using Query Analyzer with one of the problem logins and run ... the following in the context of your demodata and accounts databases: ... This will return the security context used to access the database. ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)