Home Forums SQL Server 2005 Administering Backup Operators -- what are the BEST practices for SQL backups? RE: Backup Operators -- what are the BEST practices for SQL backups?

  • December 30, 2009 at 9:07 am

    #1097506

    GSquared (12/30/2009)

    I prefer to create a domain account for that, domain\SQLBackups. Give it rights to the backup directories, give it rights in SQL, and be done with it.

    OK, I think this may be the correct way to do it.

    But what AD group do you add it to, or just leave it in the Users group?

    When you create a SQL Login with this account, what Server Role(s) do you add it to?

    Do you have to then give it Database Role(s) in each database within an instance? db_backupoperator?

    Do you have to go through each backup directory and give the Windows Login permissions to that? What are the least permissions you give it?

    What, if anything, happens if you change this domain account's password?

    Thanx!!