I have scedule transaction log back every weekend. nut still no use. Trans log file is growing day by day.
You need to backup the log a lot more than once a week. Depending on activity, once or twice an hour.
How often are you backing up the log? Is you query the sys.databases view, what does the column log_reuse_wait_desc show for the DB in question?
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass