We help IT Professionals succeed at work.

Permission require to truncate transaction log

Keng0499
Keng0499 asked
on
1,747 Views
Last Modified: 2014-12-05
Any advice what is the permission require to perform truncate transaction log (non sa equivalent)?
Comment
Watch Question

Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

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
CERTIFIED EXPERT
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
CERTIFIED EXPERT

Commented:
What is it you are trying to do? Is it to reclaim space?
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.