data-konzept

'I received a question from the backup engineers  configuring a new backup system. They are working with different technology owners to set up the different schedules. As part of this checklist they asked me whether they should trigger a transaction log backup after the FULL BACKUP of databases in the SIMPLE RECOVERY model?

My response to this question included a brief explanation about how SQL Server transaction logs are managed under the SIMPLE RECOVERY model. When a SQL Server database is configured with SIMPLE RECOVERY - a DBA needs to understand that transaction logs will be immediately truncated. The purpose is to remove the inactive virtual log files.'...

http://www.sqlserver-dba.com/2016/09/is-a-log-backup-allowed-on-a-simple-recovery-database.html