Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to backup the SQL-Server 2005 default trace log files (%sqlserverpath%\MSSQL\LOG\log_*.trc) and when it is created it isnt inheriting the directory file permissions (Windows 2003 Server) so I get access denied to do the file copy with my "backup service" user. Any idea?

share|improve this question

SQL Server now ACLs the trace files with the same user permissions as that of the database files. This is usually the service account SQL Server executes under and the Computer\Administrators group. The permissions of the directory are no longer inherited.

The owner of the trace files must explicitly grant security permissions to others in accordance with security policies and company guidelines.

share|improve this answer
Thanks pk, I understand, but I dind't like it, becasuse I don't want to check if a new file is created in each database server every day. – Santiago Mar 23 '11 at 19:26
up vote 0 down vote accepted

Finally on my maintenance plan (a batch file on task scheduler) I add a change permision code like this:

cacls "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\*.trc" /E /G backupserviceaccount:R /T

Jope this help someone else!

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.