Deletion of Transaction Log File

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Deletion of Transaction Log File

Author

Topic

udanak
Starting Member

3 Posts

Posted - 2006-03-09 : 06:58:49

Hi all,
my data base's Transaction log file is more than 20GB.i haven't deleted it since we installed the DB.Is it ok if i delete it now? my MDF file is more than 5GB.what are the precautions i should take b4 i delete this file?
Thanks all in advance for rplyin me in this context..

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-03-09 : 07:14:36

http://www.nigelrivett.net/SQLAdmin/TransactionLogFileGrows_1.html

Go with the flow & have fun! Else fight the flow

Frank Kalis
Constraint Violating Yak Guru

413 Posts

Posted - 2006-03-09 : 07:15:05

This is a FAQ in almost any SQL Server related community. A simple search would have revealed usefule information like
http://support.microsoft.com/default.aspx?scid=kb;EN-US;256650
http://support.microsoft.com/default.aspx?scid=kb;EN-US;272318
http://support.microsoft.com/default.aspx?scid=kb;en-us;907511

However, if you prefer a rather brute-force method, detach the db, delete the log, attach the db. But don't consider this "best practise".

--
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt? http://www.insidesql.de/blogs

Kristen
Test

22859 Posts

Posted - 2006-03-09 : 12:54:13

Hi udanak, Welcome to SQL Team!

See also: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Why%20is%20my%20LDF%20Log%20File%20so%20big

Kristen

udanak
Starting Member

3 Posts

Posted - 2006-03-27 : 05:15:25

Hi All,
Thnx for all who replied me in the previous context.i experimented somthing like this... i detached a sample DB. deleted the LDF file and then attached the MDF agin.The Db was up and ran , but jz want to know wherther what i did was right or wrong.Invite u all to criticise that.

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-03-27 : 09:21:39

quote:
Originally posted by udanak

Hi All,
Thnx for all who replied me in the previous context.i experimented somthing like this... i detached a sample DB. deleted the LDF file and then attached the MDF agin.The Db was up and ran , but jz want to know wherther what i did was right or wrong.Invite u all to criticise that.

No. What you did is an extremely bad idea.

What you should do is setup regular database backups and transaction log backups. Run a database backup at least once per day, and run transaction log backups about every 15 minutes. This will keep the size of the transaction logs under control.

Also, it doesn't sound like you really know what all of this is about. You really need to read the sections on backup and recovery in SQL Server Books Online.

CODO ERGO SUM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources