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-11-19 : 08:30:56
|
| Manav writes "How to reduce the size of (ldf file) in case my LDF size is 2.5GBbut my MDF file is only of 55 MB.please let me know how it is possible." |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-11-19 : 08:36:00
|
| You can use DBCC SHRINKFILE which should truncate your log. If you need the transactions within your log, then you will not be able to do this.***************************************Death must absolutely come to enemies of the code! |
 |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-11-19 : 08:36:28
|
| Hmmm... There were quite a few topics on this issue recently. Search the forums (especially Administration).Otherwise look in BOL on DBCC_SHRINKDATABASE, DBCC_SHRINKFILE,... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-11-19 : 14:13:42
|
| You'll want to truncate the log before you do the shrinking that way it can be shrunk even more. See BOL as was suggested. |
|
|
|
|
|
|
Reduce the size of trasaction log(ldf file)