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: SBS2003, NTBackup-Fehler
    ... Windows Server 2003 to resolve some VSS snapshot issues ... Backup fails on a computer that is running Small Business Server 2003 ... Die Sicherung kann nicht fortgesetzt werden. ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.de.german.backoffice.smallbiz)
  • 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: SBS 2008, Exchange Backup fails backup marked as completed suc
    ... I also dismounted both mail databases (public folders and mail ... and the /mh returned an info that the exchange backup hasn't been run ... There is another problem with the same server. ... No service has been started prior to the freeze ...
    (microsoft.public.windows.server.sbs)