Permission require to truncate transaction log

Keng0499
Keng0499 used Ask the Experts™
on
Any advice what is the permission require to perform truncate transaction log (non sa equivalent)?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
to perform truncate log, you need the backup log permission:
http://msdn.microsoft.com/en-us/library/ms179478.aspx
Security -  Permissions
BACKUP DATABASE and BACKUP LOG permissions default to members of the sysadmin fixed server role and the db_owner and db_backupoperator fixed database roles.

Author

Commented:
So, if the user has BACKUP DATABASE and BACKUP LOG permission, than it should truncate the log also.
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009

Commented:
the user could truncate the log

however, truncating the log is not a regular action to be executed, only if really needed
typically, if the log file has grown MUCH too large, and you need to bring back the size to a reasonable size
in which case to not is that if you expect the log file to SHRINK as a result of the truncate log statement, you did not yet understand fully how the transaction log file works, and you should do some readings on that subject
What is it you are trying to do? Is it to reclaim space?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial