InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 23:27:08 GMT20http://www.sqlservercentral.com/Forums/Topic1357128-1292-1.aspxThanks GilaMonster :)Tue, 11 Sep 2012 22:37:15 GMTS-322532http://www.sqlservercentral.com/Forums/Topic1357128-1292-1.aspxPlease read through this - [url=http://www.sqlservercentral.com/articles/64582/]Managing Transaction Logs[/url] and this: [url]http://www.sqlservercentral.com/articles/Transaction+Log/72488/[/url]Tue, 11 Sep 2012 02:50:50 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1357128-1292-1.aspx[quote][b]S-322532 (9/11/2012)[/b][hr]Hi Perry,Yes, we have. Kindly tell me what should i do ?[/quote]Ensure that it is running successfully, check the job history to ensure it doesnt fail.A common problem I have seen is the log backup job fails due to lack of space on the backup driveTue, 11 Sep 2012 02:03:02 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1357128-1292-1.aspxHi Perry,Yes, we have. Kindly tell me what should i do ?Tue, 11 Sep 2012 01:42:36 GMTS-322532http://www.sqlservercentral.com/Forums/Topic1357128-1292-1.aspx[quote][b]S-322532 (9/11/2012)[/b][hr]Hi,The recovery model is [b]FULL[/b][/quote]Do you have transaction log backups in force for this database either via scripts or a maintenance plan?Tue, 11 Sep 2012 01:35:08 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1357128-1292-1.aspxHi,The recovery model is [b]FULL[/b]Tue, 11 Sep 2012 01:32:39 GMTS-322532http://www.sqlservercentral.com/Forums/Topic1357128-1292-1.aspxwhat is the recovery model used on the database?When running in full recovery you must ensure you have transactioon log backups in place to truncate the inactive portions of the log.Tue, 11 Sep 2012 01:24:42 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1357128-1292-1.aspxI'm using Sql Server 2005.When i tried to compile a stored procedure i got the below messageThe transaction log for database 'CDGSYSNCV' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databasesand when i ran the query below[b]select log_reuse_wait_desc, * from sys.databases where name ='CDGSYSNCV'[/b]and found the [b]log_reuse_wait_desc[/b] as [b]'LOG_BACKUP'[/b]when i checked here at [url]http://msdn.microsoft.com/en-us/library/ms178534.aspx[/url]i found a note - [b]If the reason is LOG_BACKUP, it may take two backups to actually free the space.[/b]So what should i do. Can anyone help me on this as i don't have control over backup process at my office.ThanksMon, 10 Sep 2012 22:17:35 GMTS-322532