Minimum permission required to do a TLog backup?

Hyper-V specific discussions

Minimum permission required to do a TLog backup?

Veeam Logoby Someonenew2014 » Wed Jan 13, 2016 10:43 am

Hi,

We are running backup over MSSQL. The problem is that Veeam documentation required sysadmin permission which violate security policy.

We give backup operator to do full and Tlog backups. It is failed with error
Code: Select all
: Failed to backup SQL instance  databases:            Code = 0x80040e14

                Code meaning = IDispatch error #3092

                Source = Microsoft OLE DB Provider for SQL Server

                Description = The user does not have permission to perform this action.

COM error:  Code: 0x80040e14

Once sysadmin give. Backup successes

Any idea or workaround ?
Someonenew2014
Enthusiast
 
Posts: 54
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm

Re: Minimum permission required to do a TLog backup?

Veeam Logoby Vitaliy S. » Wed Jan 13, 2016 11:43 am

Try to use these permission list and let us know if it helps > account requires local admin rights
Vitaliy S.
Veeam Software
 
Posts: 19564
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Minimum permission required to do a TLog backup?

Veeam Logoby Someonenew2014 » Sun Jan 17, 2016 6:02 pm 1 person likes this post

Thanks Vitaliy. Worked great.
Someonenew2014
Enthusiast
 
Posts: 54
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm


Return to Microsoft Hyper-V



Who is online

Users browsing this forum: No registered users and 8 guests