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: Yesterday @ 7:03 AM
Points: 590, Visits: 1,327
"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
Naga.Rohitkumar
Post #1368300
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse