Un avantaj al Full Recovery Model este posibilitatea efectuarii de Point-In-Time recovery. Personal, in cazul ilustrat, as face backup full in fiecare seara, as face truncate la log (mentinand evident Full Recovery Model). Daca totusi va permiteti sa pierdeti activitatea pe o zi atunci Simple Recovery Model e mai eficient.

---

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