05-12-2011 12:47 AM
we have sql2005, be2010 and windows2008R2 environment.
when i take full backup on sql database, the log will not truncate or remove. i use simple recovery mode.
i saw on website and manual it will truncate the log. how can i remove logs?
05-12-2011 12:57 AM
After Full backup run "Log - Back up transaction log". This job wil truncate committed transactions.
05-12-2011 01:33 AM
If you are using simple recovery mode, you don't have to truncate the logs. In this mode, the SQL Server will automatically truncate the logs when a commit is done.
You only need to truncate the logs when you are using Full Recovery Mode.
05-12-2011 09:06 PM
I need to research again how it on earth truncate the log or not.
the above answer make me confused.
thanks both.