rishgup (10/20/2008)
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability