Extreme server log growth with "decrypt encrypted objects"
MckMurray
Posts: 37 Bronze 4
I am new to SQL compare and was trying it out using the default project options when I noticed that every compare operation was adding ~400 MB to my error log file. Looking in the logs there were thousands of rows of what appear to be pages of data. Over the course of two days it completely filled up the available space on my drive.
With some troubleshooting this appears to be due to the option "decrypt encrypted objects", which I have since turned off.
Is this expected behavior?
With some troubleshooting this appears to be due to the option "decrypt encrypted objects", which I have since turned off.
Is this expected behavior?
Comments
In the meantime, you should be able to change the logging options here: https://documentation.red-gate.com/disp ... +log+files - hopefully this fixes the problem for now.
Elsewhere in the forums I came across this post from several years and many versions ago which may be related? I'm definitely seeing "DBCC 3604 ON" and "DBCC 3604 OFF" in the logs.
https://forums.red-gate.com/viewtopic.php?t=10817
I'm hoping we can take a look at the code for decrypting objects so that it spams 3604 less often - I think at the moment it's trying a bit too hard to be conservative (to make sure 3604 is never set when it shouldn't be)
Thanks
I'll try it again with the option enabled and see if that fixes it. Thanks
Edit: Sure enough, that was the culprit - a compare operation that previously logged > 787 MB just finished at < 3MB. Thanks for the pointer!