decrease the size of log file

Question

decrease the size of log file

ramyours2003

SSChampion

Points: 12266
More actions
April 2, 2014 at 6:29 pm

#285299

one of the tlog file is configured as initial 1 TB , because of that we doint have space on the drive , is it possible to decrease the initial size of the log file .

Viewing 4 posts - 1 through 3 (of 3 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

ramyours2003 (4/2/2014)
one of the tlog file is configured as initial 1 TB , because of that we doint have space on the drive , is it possible to decrease the initial size of the log file .

Yes you can decrease the size of the log file by using dbcc shrinkfile. Before doing that, you should figure out what kind of size you really need in your tlog.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 2

You might also want to figure out how it got so big. If there's code that makes it that big or you're not doing TLog backups, that could make for serious problems.

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

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 3

ramyours2003 (4/2/2014)
one of the tlog file is configured as initial 1 TB , because of that we doint have space on the drive , is it possible to decrease the initial size of the log file .

You need to investigate why it was set to ITB intially. If it's going to grow to that size anyway, shrinking the log file won't be of much use. Just investigate what's causing the log to grow.

--

SQLBuddy