Re: cant delete odbc tracing file..

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dinesh T.K (tkdinesh_at_nospam.mail.tkdinesh.com)
Date: 06/07/04 

Date: Mon, 7 Jun 2004 15:12:04 +0530

Rea,

Refer the below snippet from :
'PRB: ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk Space'
http://support.microsoft.com/?id=268591

<start quote>
To turn off ODBC Tracing and remove the associated file, follow these steps:
  1.. To disable ODBC Tracing:
    1.. For Microsoft Windows NT 4.0:
      a.. On the Start menu, click on Control Panel, and then click on Data
Sources(ODBC).
      b.. Click on the Tracing tab, and choose Stop Tracing Now.
    2.. For Microsoft Windows 2000:
      a.. On the Start menu, click on Control Panel, click on Administrative
Tools, and then click on Data Sources (ODBC).
      b.. Click on the Tracing tab, and choose Stop Tracing Now.
  2.. Stop all ODBC applications, and stop SQL Server. In some cases it may
be necessary to reboot the server to free up the file so that it can be
deleted.
  3.. Delete the ODBC Tracing file, usually called "C:\SQL.LOG."
  4.. Restart SQL Server.
<end quote> 

--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Rea Peleg" <rea_p@afek.co.il> wrote in message
news:eKbGsGHTEHA.1472@TK2MSFTNGP09.phx.gbl...
> Hi all
> I can not delete the odbc manager tracing file.
> Even after disabling tracing (in the odbc manager)
> i get a windows massage saing another program is using the odbc tracing
> file...
> Can i stop the odbc manager service??
> What other programs may be using this log?
> There is no other runing programm or sql server job.
> Please help, this file is growing so fast!
> TIA
> Rea
>
>

Relevant Pages

  • Re: can not delete odbc tracing file
    ... It appears that not only should one disable odbc tracing - in order to ... "Robert Sundström" wrote in message ... >> I can not delete the odbc manager tracing file. ... >> There is no other runing programm or sql server job. ...
    (microsoft.public.data.odbc)
  • Re: SQL Client
    ... >> I'm looking for a faster SQL Server client. ... > See "ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk ... > The SQL.LOG file can grow very large and consume all existing disk space ...
    (microsoft.public.sqlserver.server)
  • Re: cant delete odbc tracing file..
    ... ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk ... Stop all ODBC applications, and stop SQL Server. ...
    (microsoft.public.sqlserver.odbc)
  • Re: SQL Client
    ... See "ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk Space" ... There may be a high input/output overhead associated with ODBC Trace, ...
    (microsoft.public.sqlserver.server)