Help

Start a discussion
UNSOLVED

75apollo

updated

3 years ago

7

75apollo

1 Rookie

•

3 Posts

0

224

October 3rd, 2023 06:53

SQL backups minimum permissions required

Hi team,

I have a customer asking for the bare minimum privileges required for sql backup and restore. They are not comfortable with granting sysadmin and full windows admin rights to the account.

They uses a service account to trigger the backups and also wanted to know if they can use a non-interactive account instead.

Thanks,

Joseph

  • BE

    Brahmaiah E

    1 Rookie

    •

    73 Posts

    0

    0

    Posted October 5th, 2023 17:26

    Without sysadmin permissions you can't do backup and restore

  • C

    crazyrov

    6 Operator

    •

    1319 Posts

    0

    1

    Posted October 21st, 2023 03:53

    FYI - https://www.dell.com/support/manuals/en-in/networker-module-for-microsoft/nw_p_nmm_sqlvdi_guide_19.9/access-privileges-for-backup-and-recovery?guid=guid-861e5421-1134-4443-85af-58a1235b3d49&lang=en-us

  • G

    Garfield33

    1 Rookie

    •

    11 Posts

    0

    0

    Posted February 28th, 2024 12:27

    sound like common political issue between teams. DBA team want to backup to local shares :) 

    to justify them that you need these rights for installation of NMM, show statistics of dedupllication for SQl client using NMM and snapshoting sql server plus file level backup of flat files. this might convince them . ;)

Dell Support Resources

Latest Solutions

View More