Solved

How to Clear the database log file.

Posted on 2003-11-05
5
2,549 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 6

Accepted Solution

by:
lausz earned 25 total points
ID: 9689246
0
 
LVL 69

Expert Comment

by:Scott Pletcher
ID: 9689665
Points awarded: 0

Questions Asked: 7
Questions Open:  7
0
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 9689687
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.

749 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