• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1121
  • Last Modified:

Permission require to truncate transaction log

Any advice what is the permission require to perform truncate transaction log (non sa equivalent)?
  • 2
1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
to perform truncate log, you need the backup log permission:
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.
Keng0499Author Commented:
So, if the user has BACKUP DATABASE and BACKUP LOG permission, than it should truncate the log also.
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
Gerald ConnollyCommented:
What is it you are trying to do? Is it to reclaim space?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now