Blog
Projects
About
Backtrack:
Blog
›
Required minimal permissions t…
Email this to a friend
Required minimal permissions to backup Microsoft SQL Server using Veeam
posted on December 9th 2020, at 10:27
by
lunarg
To backup Microsoft SQL Server, the account used for VM-side processing (application aware processing) requires certain permissions. Veeam recommends assigning the sysadmin role on the SQL Server but it is also possible to assign minimal permissions on the databases it needs to backup, which is the preferred method for security hardening.
The User Guide for VMware vSphere outlines the required permissions as well but for convenience, I've listed them here as well.
Instance-level roles:
Assign these roles:public
dbcreator
Database-level roles:
Assign these roles:
System databases master and model:db_backupoperator
db_datareader
public
System database msdb:db_backupoperator
db_dat
...
read more
Send a link to this post to yourself or a friend.
Send to e-mail
:
Your name:
Your e-mail:
Captcha:
Type the letters and numbers as shown.
Not readable?
Get another
.
Information entered is solely used for sending a one-time e-mail, and is not retained and/or passed on to a third party.
Tags
computer
windows
software
vmware
microsoft
linux
exchange
hardware
network
news
mac
powershell
home
office365
msoffice
ad
server
sqlserver
dell
soaring
internet
esx
mssql
rds
sbs
events
powercli
terminalserver
virtualization
antivirus
Archive
«
‹
October 2024
›
»
Sun
Mon
Tue
Wed
Thu
Fri
Sat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Links
-
@harkx
-
Cats & Dogs
-
Jargon-free Security Guide
Quote
«
You only find out who is swimming naked when the tide goes out.
»
Warren Buffett
Contact
© 2009-2024 Black Manticore – all rights reserved
code by
lunarg
, design by
SuriAmanah
, hosted at Cats&Dogs