Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 941
  • Last Modified:

Permission require to truncate transaction log

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

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

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