Forum Discussion
banco de dados com recovery full - log cheio
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?
- This is an English spoken forum, so please post your question in English or to a localized forum.
Olafolafhelper , 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?
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
