October 29, 2007 at 2:05 am
My hard disk space is low due to the SQL log file in C:\Documents and Settings\Admin\Local Settings\Temp folder. it has grown to 6 GB.
Any work around ???
October 29, 2007 at 2:34 am
Make backup database with truncation log option.
MP
October 29, 2007 at 2:50 am
Dbcc Shrinkfile(logfile_name,1)
this will help certainly
rahul arora mca 04/01
ncce israna,panipat
hry,india
October 29, 2007 at 3:04 am
chec this out!!!!!!!!!!!!
http://vyaskn.tripod.com/sql_server_administration_best_practices.htm
October 29, 2007 at 4:10 am
Didn't help.
I get error when I run the following:
Dbcc Shrinkfile('C:\Documents and Settings\Admin\Local Settings\Temp\SQL.txt',1)
Server: Msg 8985, Level 16, State 1, Line 1
Could not locate file 'C:\Documents and Settings\Admin\Local Settings\Temp\SQL.txt' in sysfiles.
I have to immediately recover 6GB space from my hard disk.
October 29, 2007 at 4:22 am
Ok, if 'C:\Documents and Settings\Admin\Local Settings\Temp\SQL.txt' is the file name then it's nothing to do with SQL Server.
Its the log file created by an ODBC datasource.
Check this,
http://support.microsoft.com/kb/268591
--------------------
Colt 45 - the original point and click interface
October 29, 2007 at 4:25 am
It's not likely that a log file would have the extension ".txt"...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 29, 2007 at 6:42 am
Thanks PhilCart,
ODBC tracing was on, and so it was eating up the hard disk space. Switched Off the tracing and deleted the SQL log file. Now its okay.
October 29, 2007 at 5:39 pm
OH! How embarassing... I thought you were talking about "LDF's"... sorry...
--Jeff Moden
Change is inevitable... Change for the better is not.
April 23, 2008 at 2:07 pm
Just 8GB? I just deleted one that was 50GB...oh the pleasures of 1TB HDDs...
😀
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply