Re: server roles for backup

From: Gregory A. Larsen (gregalarsen_at_msn.com)
Date: 12/13/04 

Date: Mon, 13 Dec 2004 14:29:19 -0800

No the "diskadmin" server role does not give logins access to perform
database backups. This role is an artifact of 6.5. In order to give the
operators access to perform backups you can give them access to the
"db_backupoperator" role. Although this role will not allow them to restore
databases. 

-- 
----------------------------------------------------------------------------
----------------------------------------------------------------------------
-
Need SQL Server Examples check out my website
http://www.geocities.com/sqlserverexamples
"Dan D." <DanD@discussions.microsoft.com> wrote in message
news:41CC1E29-A101-414E-9089-5946CEE29503@microsoft.com...
> Using SS2000. I'm using Veritas software for backups. Will giving the
> tapeadmin user the database server role of disk administrators give the
user
> enough permissions to backup and restore the databases?
>
> Thanks,
> -- 
> Dan D.

Relevant Pages

  • Re: Error executing Backup
    ... For RESTORE you cannot use db_backup operator if the database doesn't exist, ... dbcreator server role should do. ... I've configure "HP Omniback" to perform backups on ... configured this account i assign this account the "System ...
    (microsoft.public.sqlserver.server)
  • Re: server roles for backup
    ... > operators access to perform backups you can give them access to the ... >> tapeadmin user the database server role of disk administrators give the ...
    (microsoft.public.sqlserver.server)
  • 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: Log Shipping and Full Backup Frequency. Advice?
    ... The transaction log is different; it is a recording of database actions. ... And, if you restore from any of these, you only get that state. ... This is not the case with the transaction log or its backups. ...
    (microsoft.public.sqlserver.server)
  • Re: Pervasive SQL 8.6
    ... and backups are done by copying the files off to tape - ... you'll want to have lots of memory on the server -- ... > drives for the database files. ... > some settings AWAY from what was normally considered optimal in order ...
    (comp.databases.btrieve)