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 |
|
panthagani
Yak Posting Veteran
58 Posts |
 Posted - 2008-03-14 : 04:46:04
|
| I have a database on SQL Server 2000. I took a full back up of the database but the transaction log backup (ltf file) is still showing as 25 GB. I re ran the full backup with no luck. Please help: How can I reduce the size of the ltf file?Thank you. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-14 : 09:58:05
|
| http://support.microsoft.com/kb/272318 |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-14 : 14:58:44
|
| I'm not familiar with an ltf as the file extension.But the key is that you either need to start performing transaction log backups or switch your recovery model to SIMPLE. Do you require point in time recovery in case of a restore?Running full backups does nothing to the transaction log and especially the transaction log backup (in terms of size that is).Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
JeBoy
Starting Member
7 Posts |
Posted - 2008-03-17 : 03:46:49
|
| RUN DBCC SHINKFILE |
|
|
|
|
|
|
URGENT: Transaction log backup not releasing space