Re: Permissions required to restore a database

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 01/18/05 

Date: Tue, 18 Jan 2005 12:35:07 -0600

This is from Books Online:

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. 

-- 
Keith
"Diana" <anonymous@discussions.microsoft.com> wrote in message
news:154201c4fd89$92d7a750$a501280a@phx.gbl...
> Hi,
> I need to restore a database to a new server.  What are
> the minimum permissions will I need to perform this task?
> Thanks,
> Diana
>
>

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: 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: sql 7.0 to sql 2000 upgrade user/permissions
    ... I'm familiar with the sp_change_users_login and the sid problems. ... users are being restored to the database, ... It seems as if it has to do with the permissions to grant permissions. ... >> the restore from enterprise manager. ...
    (microsoft.public.sqlserver.security)
  • Re: Rights for backup/restore
    ... 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.security)
  • Re: what permission do a "regular user" need to do backup/restore
    ... the sysadmin fixed server role and db_backupoperator fixed database roles. ... DATABASE permissions to be able to execute RESTORE. ... RESTORE permissions default to members of the sysadmin and dbcreator fixed ... the db_owner fixed database role do not have RESTORE permissions. ...
    (microsoft.public.sqlserver.security)