After working with Microsoft Partner Support (generally I have good response from this group) on and off for a few months, I called Microsoft support and had a SQL tech walk me through the issue.
There is a handy query you can run to see what your databases are doing…
select name,log_reuse_wait,log_reuse_wait_desc from sys.databases
Why this is occurring I can not say but the solution was to force a backup of the logs:
According to the MS support tech, I may need to do this 4 or 5 times, which struck me as VERY odd. Even after doing this that number of times I found the SELECT NANE,LOG_REUSE_WAIT… command often showed the same results.
Regardless the next step was to manually run a Shrink:
Again, according to the MS support tech, this can/should be run multiple times to get the size down.
In my case this process shrunk my .LDF’s from 35GB to .35GB which is about where they should be.
Now I need to wait and see if the SHRINK in my scheduled Maintenance Plan works.
This website uses cookies.