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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-05 : 08:08:48
|
| John writes "How do i clear log files ?how do i reduce the size of the log file ? for example if currently the .ldf file is assigned 100 MB, I want to reduce it to 50 MB.. How do i do this..JOHN" |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-08-05 : 08:31:36
|
| Backing up your DB should empty out the unused portion of your transaction log. However this seems not to work for some people. As ure fire way to do it is to use sp_detachdb and sp_attachdb (see BOL). Make sure you do a db backup first!! This will create a new minimum size log file.You could also search this site for other solutions as this question comes up ALL the time.Paul |
 |
|
|
|
|
|
SQL Server LOG Files (.ldf)