Forum Discussion
banco de dados com recovery full - log cheio
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?
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
- The file .ldf is growing and when I do backup full its not decrease
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.databasesto see, why VLF's are not released, e.g. may cause by faulty log shipping or replication.