Re: Backup Restore of DB

I would read the BOL reference for backinging up database permissions...

do a find for "permissions".

Backup
http://msdn2.microsoft.com/en-us/library/ms186865.aspx
you are most likely looking for the db_backupoperator database role.
http://msdn2.microsoft.com/en-us/library/ms189041.aspx


Restore
http://msdn2.microsoft.com/en-us/library/ms186858.aspx
you are most likely looking for the db_dbcreator database role.
http://msdn2.microsoft.com/en-us/library/ms176014.aspx

That should be what you need...

--
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/


"Mario" <Mario@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:B42FF432-3BF8-4B33-A286-5A955BC9945D@xxxxxxxxxxxxxxxx
Hi,

Newbie to Database administration. I would like to know what kind of
permission do I need to give a developer so that he can do restore/backup of
database other then the system DB?

Many thanks

.

Relevant Pages

  • Re: User rights
    ... >DATABASE permissions to be able to execute RESTORE. ... >the db_owner fixed database role do not have RESTORE ... >I support the Professional Association of SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: User rights
    ... >DATABASE permissions to be able to execute RESTORE. ... >server roles and the owner of the database. ... >the db_owner fixed database role do not have RESTORE ...
    (microsoft.public.sqlserver.server)
  • Re: change user1 access changes user2 access
    ... name, a password, I select a database to login to, then go ... then in the Permit In Database Role window, ... public, I click on properties, then I click on Permissions ... > When you are giving permissions to User1, ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Security & User-Level Access
    ... Ian O'Betz ... In the database, I was told that different users need to ... Certain members in the Members table need to have access to ... > db_securityadmin database role, in order to grant him permissions to grant ...
    (microsoft.public.sqlserver.security)
  • Re: Adding permissions to an AD user on a remote database
    ... not if it's a member of a database role. ... "Indicates whether the current user is a member of the specified Microsoft ... Windows group or Microsoft SQL Server database role. ...
    (microsoft.public.sqlserver.security)