# How to read SQL Server log trace(log.trc)?

**URL:** <https://discuss.elastic.co/t/how-to-read-sql-server-log-trace-log-trc/197613>\
**Category:** Logstash\
**Created:** [September 1, 2019, 6:16am UTC](https://discuss.elastic.co/t/how-to-read-sql-server-log-trace-log-trc/197613 "2019-09-01T06:16:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sundar\_elk](https://avatars.discourse-cdn.com/v4/letter/s/db5fbb/32.png) [@sundar\_elk](https://discuss.elastic.co/u/sundar_elk)\
**Post date:** [September 1, 2019, 6:16am UTC](https://discuss.elastic.co/t/how-to-read-sql-server-log-trace-log-trc/197613/1 "2019-09-01T06:16:08Z")

</div>

Hi Team,

Use case :- Reading SQL server log trace file.  
file name and extension :- log.trc  
file path :- Program Files/Microsoft SQL Server/MSSQL13.MSSQLSERVER/MSSQL/Log/log\_64.trc

I tried to read .trc file directly from logstash by using tail but data showing is not readable format.  
Do we have this feature is available in Elasticsearch. Can you please advice me how to read SQL server log trace file.

Thanks in advance!!

Thanks  
Sundar

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 29, 2019, 6:20am UTC](https://discuss.elastic.co/t/how-to-read-sql-server-log-trace-log-trc/197613/2 "2019-09-29T06:20:45Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.