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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

After reading this article,

http://www.red-gate.com/supportcenter/content/knowledgebase/SQL_Backup/KB200710000173

I have some problems configuring point 2) and 3):

2) Create a SQL Server login that has the ability to backup (and restore) databases (y) by adding it to the SYSADMIN server role.

3) Add the domain account (x) to a security group on the SQL Server computer that has sufficient privileges to log on as a service, etc.

Where can I find detailed instructions/videos on how to accomplish them?

Thanks.

share|improve this question

To answer your questions directly:

2) In order to add a login to the sysadmin fixed server role you can utilize ALTER SERVER ROLE ... ADD MEMBER (2012) or sp_addsrvrolemember (pre-2012). Here would be an example:

exec sp_addsrvrolemember 'yourLoginName', 'sysadmin';

3) Without having to reiterate what's found in the following documentation, take a look at this MSDN reference on the service permissions for each SQL Server service.

share|improve this answer
    
Thomas, I'm not a DB expert and I hardly follow the documentation provided. Isn't there anything more simple? – Alberto Oct 22 '13 at 7:50

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.