Our MOM project is experiencing log file full problems on the DWH servers. The MOM_DATA database logs are full. MOM documentation states the 'MOM_DATA database and log files should be set to autogrow and unrestricted growth'. Yet SQL documentation states 'no db or log should be permitted to autogrow with unrestricted growth.
There is no MOM documentation on which recovery mode to use on the MOM_DATA database. It is currently set to full, hence our current problem. Any assistance appreciated.
There is no MOM documentation on which recovery mode to use on the MOM_DATA database. It is currently set to full, hence our current problem. Any assistance appreciated.