SQL permission for backup Exec

“Any logon that requires permissions to perform backup or restore operations should be provided membership in the following SQL Server roles:

Server Role : sysadmin

DB role : db_backupoperator, dbo_owner

Permissions required for performing restore –

Server role : sysadmin, dbcreator

DB role : db_owner”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s