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

That is weird. being a member of db_backupoperator is sufficient to do a
backup. You just have to add it to the appropriate DB's within the server.
It is a DB role - not a server role.

--
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:4F686BFE-BD24-4A72-8AAD-146C92FC6BBC@xxxxxxxxxxxxxxxx
Hi Tom,

Thanks and I manage to do it in this manner , just to share this with other
users.......
I have created a Windows acc add in the Backup Operators Group..This gives u
explicit permissions to the disk drives in a way to perform recovery
(accessing the disk drives).U need this acc to access the SSMS or entreprise
mgr,Then creating a SQL login in servers with sysadmin server roles cause
have test it with db_creator and db_backupoperator it doesnt work with it
only with sysadmin server role alone it does.

Thanks,
Aishu
MCSE,MCDBA,MCSA

"Tom Moreau" wrote:

If you have a number of servers, the script it out and use SQLCMD to
connect
to each server and run the script.

Looks like you should create a Windows group that includes the logins that
should have the backup privilege and then add that group as a login to
each
SQL Server. You can then grant read/write privileges to the domain group
on
the appropriate drives. be sure that the domain account(s) under which
your
SQL Server is running has read/write privileges on the drives.

--
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:9B9B82AF-7606-414A-8E4C-535D432E7FF7@xxxxxxxxxxxxxxxx
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: Server needs restart to allow clients to connect
    ... > if so there's a little gotcha to do with housekeeping and HDD IO which may ... From the server console, the administrator can login ... >> correspond to the backup job which is executing at that time; ...
    (microsoft.public.windows.server.sbs)
  • Re: Server needs restart to allow clients to connect
    ... if so there's a little gotcha to do with housekeeping and HDD IO which may ... From the server console, the administrator can login ... > correspond to the backup job which is executing at that time; ...
    (microsoft.public.windows.server.sbs)
  • Re: Replacing Server Hardware
    ... Download BackupExec eval - install on the old server ... Backup Mailboxes - or backup everything! ... If the user is called FRED the User profile is stored at ... Login as Administrator and run http://servername/connectcomputer to the ...
    (microsoft.public.windows.server.sbs)
  • Re: MSKB 891957, VSS Update for Windows Server 2003
    ... Well, it turns out the RDP connection dropping issue won't go away, ... level to the server in the office may have an affect on the issue. ... I just remembered I also re-installed RDP Client V6 last night as ... I left the server with user Backup logged in when I left the ...
    (microsoft.public.windows.server.general)
  • Re: MSKB 891957, VSS Update for Windows Server 2003
    ... I left the connection sit idle and checked back in an hour. ... server and browsed around for a few minutes. ... it would seem that there is still some issue with the V6 RDP ... I left the server with user Backup logged in when I left the ...
    (microsoft.public.windows.server.general)