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

You may have to CREATE CREDENTIAL for that login, in order to use the file
system (if it's a SQL Serer authenticated login). Otherwise, try granting
NTFS permissions to that Windows login.

--
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:98AFCC31-29B5-4883-A7E6-ADF8A1EDC263@xxxxxxxxxxxxxxxx
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: Renamed Windows login not found in SQL Server 2000
    ... It's almost like SQL tuck some knowledge away in an area ... of memory that only gets released on Windows stop. ... > I am running SQL Server 2000 SP2 with Windows ... > login gets corrupted) I am unable to add the new login to ...
    (microsoft.public.sqlserver.security)
  • Re: Permission question - another one
    ... If I add an Sql Login it does add the TRAVAC\ in front of the names, ... seems to be users that were setup to use SQL Server Authentication. ... RAPTOR is the Server that has SQL Server running on it. ... > " I could think I am taking permissions away from someone, ...
    (microsoft.public.sqlserver.programming)
  • Re: dsn-less connection
    ... It worked pretty much as I was hoping in prompting the user for a SQL ... Server login and was able to remove the specific dsn that's in the odbc ... straight to the SQL Server login prompt? ... with the login prompt but the Use Trusted Connection is checked on. ...
    (microsoft.public.access.security)
  • Re: Logging in irrespective of database access
    ... My problem is that in the Login section of Enterprise Manger I have to ... like there used to be in SQL 6.5. ... What's the point in having the Database Access section if the System Admin ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Logging in irrespective of the database access settings
    ... My problem is that in the Login section of Enterprise Manger I have to ... like there used to be in SQL 6.5. ... What's the point in having the Database Access section if the System Admin ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)