In this article we’ll examine how transaction logs are used in Microsoft SQL Server ... then the database should be configured with the “simple recovery model” option.

With SQL Server 2000 ... option for new databases. This model allows you to restore just part of a database or do a complete recovery. Assuming the transactions logs haven’t been damaged ...