I have been usinging the AdHoc trace file for some time now. I typically save the trace files to a network share location for retention. The location is backed up to tape regularly. Recently I have attempted to review the files using the fn_trace_gettable and have found that regarding my SQL 2008 files, I cannot access the files and receive an error "either does not exist or is not a recognizable trace file. Or there was an error opening the file". I played with my trace and did find that if I saved the file to the local drive I don't encounter any problems. I also found that I have absolutely no problems using SQL 2005 and the fileshare location.

Is there possibly a new bug regarding this matter? I thought this used to work with SQL 2008 but I'm not 100% sure I have attempted to view the log file since I have applied SP2.

Any ideas? It's not very practical to save the files to a local drive as it will continue to rollover and take up drive space and It is not secure to save this information on the server.