CODEWITHSUNDEEP
sql-server-2005database-backups
Jason Clark
Jason Clark

Reputation: 1425

Grant permissions to user for backup/restore in SQL Server

Can anyone tell me what permissions must i give to a user inside SQL Server 2005 so that this user can backup and restore a database without given him sysadmin server role ?

Upvotes: 3

Views: 11306

Answers (1)

SQLmojoe
SQLmojoe

Reputation: 2053

There is a db_backupoperator fixed database role in 2005 that should meet your requirements. See description here https://technet.microsoft.com/en-US/library/ms189612(v=sql.90).aspx

USE YourDatabase
GO
EXEC sp_addrolemember 'db_backupoperator', 'YourUser'
GO

Upvotes: 4

Related Questions