Friday, March 23, 2012

Permissions required to restore a database

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
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
>

No comments:

Post a Comment