Solved

How to Clear the database log file.

Posted on 2003-11-05
5
2,545 Views
Last Modified: 2006-11-17
Dear Sir,

When  we create Database(SQL server 2000)
.mdf,.ldf file also create. .ldf is log file of the database. now .ldf file is so big.
so, i would like to reduce or clear the old log file and create new log file. how i can do it.


Best Regards,

M. Rafeek
md_yasheen@hotmail.com
0
Comment
Question by:md_yasheen
5 Comments
 
LVL 6

Accepted Solution

by:
lausz earned 25 total points
Comment Utility
0
 
LVL 69

Expert Comment

by:ScottPletcher
Comment Utility
Points awarded: 0

Questions Asked: 7
Questions Open:  7
0
 
LVL 50

Expert Comment

by:Lowfatspread
Comment Utility
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now