craighiggins (1/3/2013)
Hi GailSorry to be a pain but what should the log_reuse_wait_desc value be?
Nothing
Anything other than that and something is preventing log reuse, meaning the log may grow if the condition persists
I have been told that that even in simple recovery mode I may still need to clear transaction logs outside of the DB backup.
Garbage. Besides, full backups don't clear the log anyway
I have just gone to set up a Tlog backup within the management studio itself, using the maintenance plan wizard, and when I go to select the databases to backup it displays a warning stating 'Databases with simple recovery will be excluded'.
Yup. simple recovery = no log backups, no point in time recovery possible. If you need to be able to restore to a point in time, then you need full recovery and log backups.
Should the Tlog actually ever fill if in simple recovery mode or is there something else I am missing?
It can. Not due to lack of log backups of course, but there are a whole bunch of other things that can prevent log reuse.
Maybe take a read through these: Managing Transaction Logs[/url], http://www.sqlservercentral.com/articles/Transaction+Log/72488/
p.s. Please in future post new questions in a new thread, not one 3 years old.
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