sanath.kumar.kura (11/26/2012)

---

Hi All,

The log file is grown to five times the database size.

Transaction Log file size 3.1GB

Database file size is 700 MB

Recovery Model : Full

backup strategy : Daily full database backup, transaction log backup for every 1 hour.

Even after this the transaction log had grown upto 3.1 GB. So could you please suggest me other than shrinking the log files regularly can i set any other option.

Note:

a)The recovery model of the database to be FUll cannot be changed to Simple

b) Log backup freuency was 4hours so i had changed it to 1 hour.

verified the log_Reuse_stats.... on query got Log_Backup

I am not sure what other options i need to set, so that i can stop shrinking the file regularly.

Regards,

Sanath Kumar