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.
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.