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

Hi Tom,

I can do that if I have one server , how abt 20 odd servers .........its
kinda painstaking job...
Have figure out assigning a limited Windows Domain acc but when login
created and put into Domain Users group still cant access the disk drives of
the servers.
So here is the questions what is the Domain Rights that I can give to the
group of user other then Domain Users and Domain Admins to access the disk
drives to not only perform sql backup but also recovery from the device....

Thanks,
Aishu


"Tom Moreau" wrote:

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: No users/groups can login to SQL Server unless part of sysadmin
    ... To make your Domain Users be able to connect to your SQL Server database, you need to create a Login for your Domain Users Domain Group and then you need to map it to the related database with datareader and datawriter role memberships. ...
    (microsoft.public.sqlserver.setup)
  • Re: Basic Windows Authentication Question
    ... Create OS Group and all the domain users to that group. ... that domain group to SQL Server. ... "Gorge Bush" wrote in message ... > as a login in SQL Server. ...
    (microsoft.public.sqlserver.security)
  • Re: Copy User permission
    ... Alex ... >I wrote an article for SQL Server Magazine that has a SP ... >> domain users to the new domain users. ... >> login id to a new login id? ...
    (microsoft.public.sqlserver.security)
  • Re: Copy User permission
    ... I wrote an article for SQL Server Magazine that has a SP to accomplish what ... > domain users to the new domain users. ... > Is there a quick way to copy permission from an existing ... > login id to a new login id? ...
    (microsoft.public.sqlserver.security)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)