SQL Server Performance Forum – Threads Archive

Transaction Log File is increasing

Hi,
I am having issue related to my log file which is continuesly increasing.Currently My database file size is approx 8GB and Log file to 13GB.To stop the increase i have changed DB recovery model to Simple but then also i am not able to reduce a lots. Is there is any safer way to reduce the size.Please advice Thanks and Regards Ravi K

You can backup the log file http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_565v.asp —————————————-
http://spaces.msn.com/members/dineshasanka

See if this helps:http://www.karaszi.com/SQLServer/info_dont_shrink.asp
You’ll find several links to the MS KB in the URL above. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

SIMPLE recovery model doesn’t take care of trasnaction log size, in order to maintain optimum size of Tlog you must issue CHECKPOINT intermittently when huge inserts were performed and during any of the optimization jobs. You can even control the log size using FULL RECOVEYR model by performing frequent BACKUP LOG in order to keep up the size of virtual log. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

What kind of operation forms the majority of transactions?

Hi, *First of all ensure that right now this database is not used by any of the user.
if no user is accessing the database then detach this database through Enterprise Manager
* Rename the logfile.
* Attach the database A new log file of about 503 kb will be created.
You can backup the existing file for the future reference of you can delete it if the database is working fine. this has 3-4% risk. but if you follow the steps described above then no problem. Akhil Ruhela
Targus Technologies P Ltd.
9899336555

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8018&SearchTerms=tran,log,shrink

]]>