Tuesday, March 20, 2012

Backup Restore of DB

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 thanksI 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@.discussions.microsoft.com> wrote in message
news:B42FF432-3BF8-4B33-A286-5A955BC9945D@.microsoft.com...
> 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 thankssql

No comments:

Post a Comment