Shrink SmartConnect Database
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
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.
Excellent!!
Thank you very much.
Rafael Ruiz