Vitaliy S. wrote:Hi David,
Log truncation is only needed for databases with Full Recovery mode, as in Simple Recovery mode SQL Server maintains only a minimal amount of information in the transaction log. And it automatically truncates transaction logs each time the database reaches a transaction checkpoint. Thus, choosing "not to truncate logs" or "truncate logs" should not have any affect on databases with Simple Recovery mode.
Vitaliy S. wrote:Maybe there was a slight misunderstanding between you and our support engineer...anyway Simple Recovery mode is a recommended configuration if you do not do anything with the logs. Our of curiosity, could you please tell me why do you bother about logs truncation for databases with Simple Recovery mode?
davidb1234 wrote:Even when using simple recovery mode log files can grow large during big transactions. However when the database is backed up the log file is truncated by SQL automatically.
davidb1234 wrote:Is the Veeam VSS backup considered a checkpoint of a simple recovery mode database forcing the truncation of the log file even when DO NOT TRUNCATE is selected?
Users browsing this forum: Bing [Bot] and 41 guests