Shrink SmartConnect Database
Rafael Ruiz asked 3 years ago
Hello,
Is there a manual/user guide to shrink or delete historical records on the SmartConnect data base? or should I just use SQL Server functionality?
Currently, the SmartConnect database is larger than the ERP database
Thanks!
Rafael Ruiz
Is there a manual/user guide to shrink or delete historical records on the SmartConnect data base? or should I just use SQL Server functionality?
Currently, the SmartConnect database is larger than the ERP database
Thanks!
Rafael Ruiz
Answers
Ethan Sorenson Staff answered 3 years ago
Rafael,
When the SmartConnect database grows large it is because the log tables can become full. The best fix is to run This Script to clear old errors out of the SmartConnect database.
When the SmartConnect database grows large it is because the log tables can become full. The best fix is to run This Script to clear old errors out of the SmartConnect database.
Rafael Ruiz replied 3 years ago Excellent!!
Thank you very much.
Rafael Ruiz