Topic: Help to understand, why the broad gull grew to 400 . And how correctly to reduce it
The basis file hardly less than 2 , and a broad gull file was inflated to 430 .
select name, recovery_model_desc, log_reuse_wait_desc from sys.databases
It turns out, recovery_model_desc = SIMPLE, and log_reuse_wait_desc = REPLICATION
The database is in a simple mode of recovery, and I suspect that a problem of it: log_reuse_wait_desc = REPLICATION.
On request (what above), all bases have log_reuse_wait_desc = NOTHING, except for the problem.
How correctly to translate problem basis in log_reuse_wait_desc = NOTHING?
And the main thing how then to reduce a basis broad gull?