backup and restore previlages of non sysadmin

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Security » backup and restore previlages of non sysadmin...

backup and restore previlages of non sysadmin

Rate Topic

Display Mode

Topic Options

Author

Message

Tara-1044200

Posted Tuesday, June 14, 2011 9:36 AM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:37 PM
Points: 983, Visits: 2,924

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

naga.rohitkumar

Posted Thursday, October 04, 2012 5:03 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 5:56 AM
Points: 525, Visits: 1,004

"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 »

Permissions