Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
elgransan
Starting Member
3 Posts |
 Posted - 2011-03-23 : 16:22:00
|
| Hello, anyone knows a way to backup/copy the default trace log files (log_*.trc), I can't do it with my "backup service" user. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
elgransan
Starting Member
3 Posts |
Posted - 2011-03-23 : 16:30:41
|
| Thanks for the reply, because an internal audit said me that I need to have a database audit record history to have evidence of all work doit on it. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
elgransan
Starting Member
3 Posts |
Posted - 2011-03-23 : 16:55:50
|
| I'm on firt stage to control audit event over databases, to start the default trace audit seemed to fit my needs. Copy open files isnt the problem, the problem is that the files didn't inherits the directory permissions so my "backup service" user couldn't do the copy. |
|
|
|
|
|
|
Backup default trace log