I am using with below version of SQL server.
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2).
One of my database transaction log file is getting full very frequently on PROD database,which i have truncated ones and shrunk ones after that i have taken full backup immediately.Again the Db tran log file grown to very big size.
We are taking the transaction log backup for evry one hour.
and The column shows log_reuse_wait=2 & log_reuse_wait_desc=LOG_BACKUP from sys.databases.
Can you please suggest me free the transaction log space without truncating the log file.
View Complete Post