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 |
|
jeroen
Starting Member
3 Posts |
 Posted - 2004-03-23 : 04:10:53
|
| My data file is 140MB Space used 133MBMy log file is 2611MB Space used 178MBCan anyone tell me how to make my logfile smaller? I Shrunk the database but de filesize of the logfile still is 2611MB.Thanks in advance,Jeroen |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-03-23 : 06:05:43
|
| Look at "Shrinking the Transaction Log" in BOL. Basically, after you shrink your database you need to SHRINKFILE the logfile.Raymond |
 |
|
|
|
|
|
Large Logfile