SQL Server 2005 databases are set to the Full recovery model by default, so you may need to start creating log backups even if you haven’t ran into problems yet.

Log Shipping and Logins. Establishing a failover server for your SQL Server? First things, first: strategize on your logins. By Eric Johnson; 06/28/2010; So you decided to set up log shipping in ...

In the SIMPLE recovery model, the log is truncated during a CHECKPOINT, when the SQL Server’s memory cache is written to disk, which happens automatically but can be performed manually.

You see, we cannot use the transaction log for recovery with the Simple recovery model. Again, the document continues: “If you need to remove the log backup chain from a database, switch to the ...