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
Solved

How to Clear the database log file.

Posted on 2003-11-05
5
2,548 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
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
I have a large data set and a SSIS package. How can I load this file in multi threading?
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 set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

840 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