Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

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.

http://blogs.msdn.com/b/psssql/archive/2008/06/25/how-it-works-trace-trc-file-security.aspx

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

 
discard

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.