Security Admin and Backup

From: C TO (anonymous_at_discussions.microsoft.com)
Date: 08/20/04

  • Next message: Russell Fields: "Re: SEE Databases" 
    Date: Fri, 20 Aug 2004 14:36:39 -0700

    2 Questions:
     1. How can I create a user that can have only backup
    right but not restore?
     2. How can I prevent a user (Software Manager) with
    Security Admin right, not to assign DBO database role to
    other users?

  • Next message: Russell Fields: "Re: SEE Databases"

    Relevant Pages

    • Re: Security Admin and Backup
      ... backup the database and he will not able to do a RESTORE. ... not to assign DBO database role to ...
      (microsoft.public.sqlserver.security)
    • Backup and Restore Files
      ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
      (microsoft.public.access.gettingstarted)
    • Re: [opensuse] About Backing Up
      ... there is a data failure we can restore. ... the restoration is to get the backup file that we first complete as it ... failure, physical destruction, or it has been half inched. ... Other data should be archived to media. ...
      (SuSE)
    • Re: Exchange in Recovery Mode
      ... On the backup SBS server, did you restore Mailbox Store from backup ... After Mailbox Store was restored, ... Create a Recovery Storage Group. ... Restore the backup to Recovery Storage Group with NTbackup. ...
      (microsoft.public.windows.server.sbs)
    • Re: RAID, SCHMAID.......
      ... And risky to change it later without a full image backup. ... partition, & then restore only the OS, but still verydoable. ... partition before an install of something you havent installed before, ... but so many ppl make a mess of things esp with today's big drives. ...
      (comp.sys.ibm.pc.hardware.storage)