File '\\Servername\F$\MSSQL\DBA\TRACE_FILES\test_servername_TRACE_200803181159.trc' either does not exist or is not a recognizable trace file. Or there was an error opening the file.

Question

File '\\Servername\F$\MSSQL\DBA\TRACE_FILES\test_servername_TRACE_200803181159.trc' either does not exist or is not a recognizable trace file. Or there was an error opening the file.

Priya20001mu

SSC Enthusiast

Points: 177
More actions
March 19, 2008 at 11:27 am

#120525

Hi,
Can anyone tell me why i am getting this error msg? I am running this trace file through stored procedures, not through profiler.
If anyone has a solution to this, please let me know.
Thanks
Pri

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

SanjayAttray SSChampion Points: 13157 More actions · Answer 1

Priya20001mu (3/19/2008)
Hi,
Can anyone tell me why i am getting this error msg? I am running this trace file through stored procedures, not through profiler.
If anyone has a solution to this, please let me know.
Thanks
Pri

Do you have proper domain permissions to read this file on other server? Are you trying to run this trace using sql account or domain account? Else just copy that trace file to your server and then run it.

SQL DBA.

Johan Bijnens SSC Guru Points: 135364 More actions · Answer 2

just my 2ct (without seeing the actual sql you submit or the actual errormessage )

Does the sqlserver service account have auth to write to the folder/file you have supplied ?

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Priya20001mu SSC Enthusiast Points: 177 More actions · Answer 3

This error msg occurs only intermitently. So i don't think it has soemthing to do with permissions etc. I Have 4 jobs running this, sometimes all the 4 run, sometimes only 1 etc.

Mohan Kumar SSCertifiable Points: 5365 More actions · Answer 4

Do you have any file backup process running for drive where you store your trace file? something like TSM. Such error is expected in that case.

[font="Verdana"]--www.sqlvillage.com[/size][/font]

Priya20001mu SSC Enthusiast Points: 177 More actions · Answer 5

No there isn't. As i told you this is intermittent. So we really do not understand why it fails one time, and runs the other time?

Do you think the trace file does not exist and that why if fails?

Can you please let me know all the possibilities you can think of.

Thanks

Mohan Kumar SSCertifiable Points: 5365 More actions · Answer 6

If you are storing your file on same machine then there is definetely a process running that locks that file (as stated in earlier post) which leads file not being accessible by Trace process for time being.

[font="Verdana"]--www.sqlvillage.com[/size][/font]