Solved

Permission require to truncate transaction log

Posted on 2014-11-20
4
470 Views
Last Modified: 2014-12-05
Any advice what is the permission require to perform truncate transaction log (non sa equivalent)?
0
Comment
Question by:Keng0499
  • 2
4 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 40454587
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
 

Author Comment

by:Keng0499
ID: 40454595
So, if the user has BACKUP DATABASE and BACKUP LOG permission, than it should truncate the log also.
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 40454605
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
 
LVL 16

Expert Comment

by:Gerald Connolly
ID: 40459372
What is it you are trying to do? Is it to reclaim space?
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

823 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question