1

I want to give our technician rights to restore one particular database from a backup file. What are the minimum rights I can give him?

Cor Blimey
  • 83
  • 5

1 Answers1

1

You could use the Server Role dbcreator to restore the database and the Database Role db_backupoperator to backup the database, as pointed out by @RBarryYoung in this great answer.

You can specify these settings in the properties of the login, selecting the tab Server Roles and User Mapping.

Community
  • 1
  • 1
Alberto Solano
  • 7,972
  • 3
  • 38
  • 61