Re: Rights for backup/restore

nntp
Date: 06/16/03

  • Next message: Russell Fields: "Re: not associated with a trusted sql server connection" 
    Date: Mon, 16 Jun 2003 08:39:26 -0700

    from books online: (note this is one of the places where the "subtle"
    difference of dbo and db_owner shows itself.)

    Permissions
    If the database being restored does not exist, the user must have CREATE
    DATABASE permissions to be able to execute RESTORE. If the database exists,
    RESTORE permissions default to members of the sysadmin and dbcreator fixed
    server roles and the owner (dbo) of the database.

    RESTORE permissions are given to roles in which membership information is
    always readily available to the server. Because fixed database role
    membership can be checked only when the database is accessible and
    undamaged, which is not always the case when RESTORE is executed, members of
    the db_owner fixed database role do not have RESTORE permissions.

    "Wayne Snyder" <wsnyder@computeredservices.com> wrote in message
    news:#xbi1nBNDHA.2788@TK2MSFTNGP10.phx.gbl...
    > If you own a database you may back it up...
    >
    > Also system administrators, db_owner role, db_backupoperator role, and
    those
    > withe backup database permission...
    >
    > "John" <john.senter@stjude.org> wrote in message
    > news:07d601c3340e$4d2c20f0$a401280a@phx.gbl...
    > > I need to find the minimum rights that a user would need
    > > to perform a backup and restore of a database in
    > > SQL2000. They are already a DBO of the database but they
    > > claim they cannot perform a restore. This user is not a
    > > DBA and I do not want to give them server admin rights.
    > >
    > > Thanks
    > > js
    >
    >

  • Next message: Russell Fields: "Re: not associated with a trusted sql server connection"

    Relevant Pages

    • Re: Making changes to existing WSS intranet
      ... I thought then that perhaps I should have created a new virtual server, ... > recreate the old site and then restore that backup to that site. ... > can check to the option to create a new content database instead of using ...
      (microsoft.public.sharepoint.windowsservices)
    • Re: Backend Exchange migrate to New Hardware (Server)
      ... Exchange mailbox stores and Exchange public folder stores. ... When you use Backup to restore Exchange databases, ... Storage Engine to restore Exchange database files and their ...
      (microsoft.public.exchange.setup)
    • 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: sql 7.0 to sql 2000 upgrade user/permissions
      ... SQL FAQ links: ... > I'm using a database restore to upgrade a sql 7.0 database to a sql ... The public user has full permissions. ...
      (microsoft.public.sqlserver.security)
    • Re: Permissions required to restore a database
      ... If the database being restored does not exist, ... DATABASE permissions to be able to execute RESTORE. ... the db_owner fixed database role do not have RESTORE permissions. ...
      (microsoft.public.sqlserver.tools)