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

Hi Tom,

Using the db_backupoperator and the db_creator roles for a sql server
login.Somehow when u try to perform a recovery from a device than it requires
a NTFS permission on the Directory of where the backup file is
located...somehow to overcome all this I had to assign a sysadmin.....Is any
workaround solution for this




Thanks,
Aishu


"Tom Moreau" wrote:

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

  • Re: Two Disaster Recovery Questions
    ... I support the Professional Association for SQL Server ... > recovery site ... > second restore at the recovery site. ...
    (microsoft.public.sqlserver.server)
  • RE: New Server installation - Disks Setup recommendations
    ... recovery purposes, for I/O distribution. ... > We actually have two SQL Server 2000 on distinct boxes that I'd like to ... > is a good setup or not. ...
    (microsoft.public.sqlserver.setup)
  • Re: torn page detection and auto shrink: performance?
    ... And I have up-to-time recovery possibility. ... Curently, database size shows 18GB, but the used space shows 8GB. ... Shirinking files, will cause that by expanding files, sql server will ... There should be enough free space to permit reindexing of this table. ...
    (comp.databases.ms-sqlserver)
  • Re: Checkpointing Not Happening in Simple Recovery Model
    ... She says that she has simple recovery and that one of them is tempdb. ... Columnist, SQL Server Professional ... >> We have at least two databases on this server in simple recovery model. ...
    (microsoft.public.sqlserver.server)
  • Re: Full or Simple Recovery ?
    ... Simple recovery will not be able to recover the part of the log UNTIL ... Wayne Snyder, MCDBA, SQL Server MVP ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ...
    (microsoft.public.sqlserver.replication)