Keng0499
asked on
Permission require to truncate transaction log
Any advice what is the permission require to perform truncate transaction log (non sa equivalent)?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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?
ASKER