-
Notifications
You must be signed in to change notification settings - Fork 267
This issue was moved to a discussion.
You can continue the conversation there. Go to discussion →
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
The database log file is too large to clean up (sqlserver) #6023
Comments
Most folks prune every hour. Your frequency likely can't keep up. |
In addition to setting up here data prune , please Is there any other way to reduce the disk space occupied by large database files or to regularly clean up database files? |
The database transaction files generated every day occupy 5G and require manual processing each time. Do you have any other configurations? Thank you |
That is a SQL server exercise, not a Mirth question. Set recovery mode to simple. I assume you have a SQL job to automate all the SQL server stuff like truncating the log on backup. If not, you should use the maintenance solution at https://ola.hallengren.com/. Best stuff ever. |
I suspect your channel may also be poorly designed and not use attachment handlers. |
Please stop posting to issues unless there is a known bug or you have a feature request. I am converting this to a discussion. |
This issue was moved to a discussion.
You can continue the conversation there. Go to discussion →
1、Connect to the database and configure it as SQL Server
![image](https://private-user-images.githubusercontent.com/32355185/290064155-a5254087-92d7-41d1-afad-1581f4c112ee.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjIyMTE3MDAsIm5iZiI6MTcyMjIxMTQwMCwicGF0aCI6Ii8zMjM1NTE4NS8yOTAwNjQxNTUtYTUyNTQwODctOTJkNy00MWQxLWFmYWQtMTU4MWY0YzExMmVlLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA3MjklMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNzI5VDAwMDMyMFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTYxY2JhOWQ3MTQwOGY5NWY4OTI5MjRkMDI4OWNkMTY4MzUzZGFjZjlhM2VlMTdhZjMwZTc5OGIyOGZhMWMxZjQmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.nCdW13mBMcEhaebJn9cplQGtkSSRbLMnlmIQ0eMQOcw)
![image](https://private-user-images.githubusercontent.com/32355185/290064696-e1819463-3c29-4ffe-9de9-6358914ff9a8.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjIyMTE3MDAsIm5iZiI6MTcyMjIxMTQwMCwicGF0aCI6Ii8zMjM1NTE4NS8yOTAwNjQ2OTYtZTE4MTk0NjMtM2MyOS00ZmZlLTlkZTktNjM1ODkxNGZmOWE4LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA3MjklMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNzI5VDAwMDMyMFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTlhZjEzZmU4ZDU0MGY4Y2JkMzAwM2QyYzdlZDcyODJkYWM1NmFhMGNhNDQ4MWM2YjVkMTE0NGJkNTBmMjYyMTImWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.QK3poCzmr2A-HXqx-iP6ZIcv3M9LMio8BhoOsOm39Nw)
![image](https://private-user-images.githubusercontent.com/32355185/290064985-f0790e7d-7a80-43fd-ab34-6f86a51616b8.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjIyMTE3MDAsIm5iZiI6MTcyMjIxMTQwMCwicGF0aCI6Ii8zMjM1NTE4NS8yOTAwNjQ5ODUtZjA3OTBlN2QtN2E4MC00M2ZkLWFiMzQtNmY4NmE1MTYxNmI4LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA3MjklMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNzI5VDAwMDMyMFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWFlMmIyMjZiZDkzMDgyMTEwNDZiNzU5N2JmNThjNTY1ZTZiMjJmNzBjOWYxODdmODE2ZTc5NGFhMzVlNzk5OGEmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.OyLoQEZaEM7ZlLuWOuMgMS9wOV7lWnK4F9uZ0QNW8JY)
![1702437873998](https://private-user-images.githubusercontent.com/32355185/290065554-9c2f7fbe-13b3-4cf0-9423-0892803eca69.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjIyMTE3MDAsIm5iZiI6MTcyMjIxMTQwMCwicGF0aCI6Ii8zMjM1NTE4NS8yOTAwNjU1NTQtOWMyZjdmYmUtMTNiMy00Y2YwLTk0MjMtMDg5MjgwM2VjYTY5LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA3MjklMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwNzI5VDAwMDMyMFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTg0OTM1YWRlZWYyNTVlOWRiMTAwNWVmYjFjNGQ3OGVkNTM0ZTk1NGIwNzE0OTU2NGMyMmE0NjA0NGI0MGY2ZTgmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.Uc6bLF-cUHfc0osB91-aeZQz5gSIQCHUNUo54wzvR50)
2、The validity period of the log is set to 2 days
3、There are three tables in the database that take up a lot of space and cannot be cleaned up
D_MC1 、D_MM1,D_M1
4、How to make scheduled cleaning of logs and database files effective
The text was updated successfully, but these errors were encountered: