SQL SERVER Transaction File LDF

Navigation
1

I have started using sql-server , in the database I have configured the transaction file to grow by 10% as needed, but up to a maximum size of 2Gb.

When the file of transactions (ldf) reaches the established limit of 2Gb, does it stagnate or is it renewing its content?

    
asked by IcuScc 28.03.2016 в 10:27
source

2 answers

1

When it reaches the maximum it stalls and it gives an Error 9002. You should make a maintenance plan that when Backup is made of the BD and Log, erase the latter to leave it clean. I leave you a microsoft link link

    
answered by 28.03.2016 / 16:47
source
1

It depends on how you have configured the recovery mode. In simple mode there is a checkpoint and the VLF are released, in full mode after a backup of the log, full or dif. So if you have full mode it is advisable to have a good backup policy

    
answered by 04.04.2016 в 20:58
Error message when compiling a struct array as an attribute Personalized access in Spring Security