Backup User - Server Role?

I wish to create a user that can backup any or all databases in our SQL
Server 2000 Instance. I thought there would be a server role for this
function, however I can only find that after I grant access of a
database to the user, then I can choose ds_backupoperator.
I want to create a user that will have the ability to backup all the
databases. I dont wish to have to come back to the server after a new
table is created and add the backup user to that table.
I want SA w/o the full privilage...am I crazy?
Any Suggestions?
TIA
Rob
Backgroup: We currently have about 10 SQL servers, and adding more in
the future. I am using SQLBackup from Idera along with HP Surestore
Tape library (60 slots,2- DLT8000 drives with 40/80 GB capacity) with
ArcServe from Computer Associates. I want to have this automated to
backup to file then tape, regardless of what databases get created.

.

Relevant Pages

  • Re: DB architecture for WSS sites on SPS server
    ... sharepoint servers or use it for other products such as SQL, ... Commvault will require a different server to be installed on (you dont ... We had purchased the Veritas SharePoint backup agent to plug into our ... recommended to create seperate databases for the content. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: DB architecture for WSS sites on SPS server
    ... sharepoint servers or use it for other products such as SQL, ... Commvault will require a different server to be installed on (you dont ... We had purchased the Veritas SharePoint backup agent to plug into our ... recommended to create seperate databases for the content. ...
    (microsoft.public.sharepoint.portalserver)
  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including ... from the source SQL Server 2000 instance to the SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: BizTalk Server 2004 ConfigFramework.exe error
    ... one BizTalk is installed on? ... machines (both for SQL and DTC) is not blocked by firewalls and new MSDTC ... Multi-computer configuration using Windows Server 2003 or Windows XP ... >>all associated databases. ...
    (microsoft.public.biztalk.general)