O metoda de a micsora dimensiunea log-ului este urmatoarea:

1. Switch to SIMPLE recovery model.

2. Shrink database.

3. Switch back to FULL recovery model.

 

Va recomand oricum sa cititi urmatorul articol: How to stop the transaction log of a SQL Server database from growing unexpectedly

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro