Re: Security Admin and Backup

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 08/21/04

  • Next message: Gordzilla: "Login failed for user 'sa'." 
    Date: Sat, 21 Aug 2004 07:18:46 +0530

    Hi,

    1. Add the user to 'db_backupoperator' role. This role allows the user to
    backup the database and he will not able to do a RESTORE.

    2. May not be possible.

    Thanks
    Hari
    MCDBA

    "C TO" <anonymous@discussions.microsoft.com> wrote in message
    news:9ff601c486fd$c6d719d0$a501280a@phx.gbl...
    > 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: Gordzilla: "Login failed for user 'sa'."

    Relevant Pages

    • 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: How do I restore from mdf and ldf files?
      ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
      (microsoft.public.sharepoint.portalserver)
    • Re: Restoring SQL Server Backups
      ... ORIGINAL BACKUP & RESTORE (MSDE Database) ... occurrenceof cachestore flush for the 'Object Plans' cachestore (part ...
      (microsoft.public.sqlserver.server)
    • Re: Restoring SQL Server Backups
      ... ORIGINAL BACKUP & RESTORE (MSDE Database) ... occurrenceof cachestore flush for the 'Object Plans' cachestore (part ...
      (microsoft.public.sqlserver.server)
    • Re: POINT IN TIME RESTORE
      ... This is what you should have done in order to do the restore as you wish: ... > 3- erase data ... > 5- restore database with norecovery ... The BACKUP DATABAE can of course be at an earlier point in time, ...
      (microsoft.public.sqlserver.server)