Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a Windows Server 2008 with Microsoft SQL Server 2008 and VERITAS NetBackup installed. Basically, this NetBackup requires a valid logon ID into the SQL Server that is powerful enough to do a backup and restoration.

I have created a local ID on the OS called backup01 and assign it to the Backup Operator group. Next, I created a login in SQL Server 2008 with for backup01 with Windows Authentication. As for server roles, I assign it as 'public' and 'sysadmin'. With this, the backup and restoration via NetBackup will always work.

However, our security policy discourage the use of sysadmin or administrator equivalent rights to be assigned to non-administrator users.

In this case, where can I find this backup operator role in Microsoft SQL Server? Or is there any guide or tutorial that walks you through on creating a new role? Thank you!

share|improve this question
    
I'm not quite familiar with this particular problem, but in general you should only grant privileges to the roles that are just sufficient to work with. I'd look at NetBackup docs for details. –  dezso Nov 10 '12 at 9:44
add comment

1 Answer

It is not a system level role, it is assigned in each database. Assign the login "public" and "db_backupoperator" roles in each database it needs to backup.

http://www.sqlbackuprestore.com/backupandrestorerights.htm

share|improve this answer
1  
Thank you for your replies @datagod. By the way, will it be capable to do restoration as well? Thanks. –  Jimmy Nov 10 '12 at 6:25
1  
Restoration requires a bit more: sqlservercentral.com/Forums/Topic1015169-391-1.aspx . –  Kevin Feasel Nov 12 '12 at 12:31
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.