Re: cant delete odbc tracing file..

From: Rea Peleg (rea_p_at_afek.co.il)
Date: 06/07/04 

Date: Mon, 7 Jun 2004 15:45:11 +0200

Thanks alot !
"Dinesh T.K" <tkdinesh@nospam.mail.tkdinesh.com> wrote in message
news:uaDVzOHTEHA.1732@TK2MSFTNGP09.phx.gbl...
> 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: Urgent. C:SQL.log is eating up disk space
    ... ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk Space ... Click on the Tracing tab, ...
    (microsoft.public.sqlserver.server)
  • 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: Log Reader
    ... that i dont know yet i could create the tracing, but now i am having a new ... > Also make sure SQL Server service account has permissions to the path you ... >> There isn't a user friendly way to read SQL Server transaction logs. ...
    (microsoft.public.sqlserver.programming)
  • Re: cant delete odbc tracing file..
    ... ODBC Tracing to SQL.LOG Can Slow SQL Server or Consume All Disk Space' ... <start quote> ... > I can not delete the odbc manager tracing file. ...
    (microsoft.public.sqlserver.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)