banco de dados com recovery full - log cheio

[articoblumenau]

olá.

Eu tenho configurado o banco de dados com o mecanismo de recovery full, e ocorre que mesmo configurando o backup do banco e o backup dos logs, o arquivo do log não é esvaziado. 

No meu entendimento, sempre após o backup full, deveria limpar os logs, mas isto não está ocorrendo.

Tem alguma configuração faltando nos jobs?

[#2]

This is an English spoken forum, so please post your question in English or to a localized forum.

Olaf

[#3]

@olafhelper , ok, I'm sorry.

Why is my data base don't clean the files log? I have configured to recovery full and I set the jobs to full backup and log backups. But, after the backup full, my logs files (.ldf) dont are cleaned.

Did I someting wrong on the backup configuration?

[#4]

@articoblumenau , what do you mean with "clean log" and how did you check this "not clean"?

A log backup release VLF = "Virtual log file" for reuse.

You can check it with

DBCC SQLPERF (Transact-SQL) - SQL Server | Microsoft Learn

sys.dm_db_log_info (Transact-SQL) - SQL Server | Microsoft Learn

[#5]

The file .ldf is growing and when I do backup full its not decrease

[#6]

@articoblumenau 

The file .ldf is growing and when I do backup full its not decrease

---

Of course not, SQL Server never shrinks files on its own, because it's an expensive IO operation.

Run 

select name, log_reuse_wait_desc
from sys.databases

to see, why VLF's are not released, e.g. may cause by faulty log shipping or replication.