cancel
Showing results for 
Search instead for 
Did you mean: 

sql logs on windows2008R2&BE2010

MyLee
Level 4

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?

3 REPLIES 3

AmolB
Moderator
Moderator
Employee Accredited Certified

After Full backup run "Log - Back up transaction log". This job wil truncate committed transactions.

pkh
Moderator
Moderator
   VIP    Certified

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.

MyLee
Level 4

I need to research again how it on earth truncate the log or not.

the above answer make me confused.

thanks both.