SQL Log File Size is Growing

Question

Post reply

SQL Log File Size is Growing

ckmoied

Ten Centuries

Points: 1092
More actions
October 29, 2007 at 2:05 am

#62876

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 ???

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Powichrowski Marek Hall of Fame Points: 3483 More actions · Answer 1

Powichrowski Marek

Hall of Fame

Points: 3483

October 29, 2007 at 2:34 am

#746108

Make backup database with truncation log option.

MP

arorarahul_0688 SSC Veteran Points: 216 More actions · Answer 2

Dbcc Shrinkfile(logfile_name,1)

this will help certainly

rahul arora mca 04/01

ncce israna,panipat

hry,india

VaiydeyanathanVS Hall of Fame Points: 3053 More actions · Answer 3

chec this out!!!!!!!!!!!!

http://vyaskn.tripod.com/sql_server_administration_best_practices.htm

ckmoied Ten Centuries Points: 1092 More actions · Answer 4

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.

philcart SSC-Forever Points: 47796 More actions · Answer 5

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

Jeff Moden SSC Guru Points: 1004414 More actions · Answer 6

It's not likely that a log file would have the extension ".txt"...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ckmoied Ten Centuries Points: 1092 More actions · Answer 7

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.

Jeff Moden SSC Guru Points: 1004414 More actions · Answer 8

OH! How embarassing... I thought you were talking about "LDF's"... sorry...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

cgnospam SSC Enthusiast Points: 156 More actions · Answer 9

Just 8GB? I just deleted one that was 50GB...oh the pleasures of 1TB HDDs...

😀