There are three Recovery Model as
- Simple: In simple Recovery Model,SQL server truncates the log ate every Transaction Checkpoint.It can not be used for disaster recovery purpose.So you can choose this one on test Server.
- Full: As name suggested,In Full recovery model SQL server truncates transaction log every time you backup it under Full recovery Model.With this you can recover database up to a certain point in time.
- Bulk-Logged: Performs logging of bulk operations.In this, Transaction
log can be backed up quicker than with the FULL recovery model.
How to see Transaction Log Sizeyou can use DBCC command for same as
You see if you choose recovery model of your database FULL,then transaction size will increase frequently.So you need to truncate transaction log on regular basis to keep it from filling up.You can schedule a job for backup and truncation transaction log or you can create maintenance plan.
You can shrink your Transaction Log File in below simple steps\