Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

backup and restore previlages of non sysadmin Expand / Collapse
Author
Message
Posted Tuesday, June 14, 2011 9:36 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, January 9, 2014 7:44 AM
Points: 988, Visits: 2,945
How can give permissions to a non sysadmin to backup and restore any database on server. I want to do this for a user on Test server.

I thought of using db_backupoperator but it is a db role but not server role.
Post #1125111
Posted Thursday, October 4, 2012 5:03 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 10, 2014 11:09 PM
Points: 549, Visits: 1,181
"nothing is better than giving a trail"

try this iam also not sure
give DBCREATOR in serverrole and db_backupoperator in database role


normaly bulkadmin and public are common to non sysadmin
check in this
http://sqlserverpedia.com/wiki/Built-In_Server_Roles_%26_Database_Roles

and one doubt why are u giving the non sysadmin [is he/she also a DBA ] these backup and restore previllages ??????/?


Thanks & Regards
NAGA.ROHITKUMAR
Post #1368300
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse