SQL Server 2008 - Service account for backups

Question

I am setting up a backup software to backup all the databases on my MS SQL Server 2008.

I want to configure a service account with administrator rights on the database. The service account have already been created in the AD, but has no rights at the moment.

How can I give database rights to my service account so that he will be able to launch backup tasks?

It has nothing to do with the backup software I am using. I just want to set up a service account for backing up SQL Server 2008. — Jonathan Rioux, May 04 '12 at 14:03

score 1 · Answer 1 · answered May 04 '12 at 14:05

1

You said you were using RedGate for this. Though this is a SQL Server configuration issue, the RedGate documentation clearly walks you through how to do this.

answered May 04 '12 at 14:05

MDMarra

100,183
32
195
326

score 0 · Accepted Answer · answered May 04 '12 at 18:18

0

USE [master]
GO
CREATE LOGIN [DOMAIN\USER] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
EXEC master..sp_addsrvrolemember @loginame = N'DOMAIN\USER', @rolename = N'sysadmin'
GO

answered May 04 '12 at 18:18

Jason Cumberland

1,559
10
13

SQL Server 2008 - Service account for backups

2 Answers2