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

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 9:24 AM
Points: 1,000, Visits: 2,979
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