Transaction Log Full

Problem

The database in question needs to be backed up which erases the transaction log data.

Solution

To help keep it from getting full the user may go into the SQL server management studio and right click on the database in question and go to properties. Click Options and set the Recovery model to Simple. This keeps the transaction log to a minimum.