Unsolved
1 Rookie
•
3 Posts
0
75
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
No Events found!
Brahmaiah E
1 Rookie
•
73 Posts
0
October 5th, 2023 17:26
Without sysadmin permissions you can't do backup and restore
crazyrov
4 Operator
•
1.3K Posts
1
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
Garfield33
1 Rookie
•
11 Posts
0
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 . ;)