How to shrink a SQL7 transaction log file?
Posted on 2007-10-01
I have a SQL7 running in NT4. The database size is about 2.5GB. The .mdf file is about 2.5GB, but the .ldf file is 7.5GB. When I back up the transaction log in SQL Enterprise Manager, that backup file is only 20MB!
Q#1. Why there is a huge size difference in the database, .ldf file and the log file backup?
Q#2. How to configure the database so the .ldf file does not 'hog' too much disk space?
Q#3. How to 'shrink' the current .ldf file? I tried cmd: dbcc shrinkdatabase (myDB, 50) does not seem to work.
Q#4. What considerations to take when deciding whether to commit the log to database or keep it in transaction log?
Thanks a lot.