Why is log_reuse_wait_desc saying LOG_BACKUP after doing a log backup?
Hi We are using SQL 2005, windows server 2003. We have 24 db in our SQL Server. We are schedule backup jobs mon to fri. Transaction log backup every one hour and schedule tue to sat( Not schedule sun & mon bcos error comes bcos there is no current db backup) My problem is 1)one db has throws continuously LOG_BACKUP on log_reuse_wait_desc of sys.databases so how to solve this? 2) During Sun and Mon Log files are growing very large due to transaction log backp not available. **How to reduce log file size during Sun and Mon?**