How to add a dedicated SQL backup service account

  1. Open SQL management studio
  2. Connect to the session as an appropriate admin user (this can be done using either Windows or SQL authentication) to the SQL instance
  3. Expand Security->Logins
  4. Right-click Logins and choose “new Login”
  5. Add the backup service account details, ensuring that you select SQL authentication and deselect “enforce password policy”
  6. Select “User mapping” on the left-hand panel tab, and ensure that ” db_backupoperator is ticked for the databases you wish to backup – you do not need to alter or add any other privileges.
  7. Choose OK
  8. Now the backup agent should be able to use this SQL service account to backup the selected databases.