SQL.log in my c:\temp folder - what is it and can I move it??

RonPro · Feb 14, 2003

Its currently over a gig. We run several databases on this server but all are on the D: drive as well as the related trans logs.

So, what is in this file, and can I move it? It is always marked with a current timestamp and appears to just get larger.

I have mtce plans on all databases that clear the trans logs during the day.

Or is it simply a function of where the tmp/temp is set up for?

tlbroadbent · Feb 14, 2003

You may have ODBC tracing turned on. Go to the Control Panel, open Data Sorces (or ODBC Data Sources), click on the Tracing tab. If the button says Stop... trace is running. Click the button to stop tracing. If you want to get the best answer for your question read faq183-874 and thread183-468158.

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

SQL.log in my c:\temp folder - what is it and can I move it??

RonPro

Programmer

tlbroadbent

MIS

Similar threads

Part and Inventory Search

Sponsor