The logs for DNN databases are very large.  I want to take steps I have done with other SQL Servers by changing the backup type from Full to Simple.   There is no throughout the day transactional backup being made so Full doesn’t give us anything.  Simple will truncate the log for each database each night.

If these databases do have transactional data that may need to be restored to a point in time. With the logs being truncated each night, the nightly backups should become much smaller (I assume)

... Are ther any good resources out there for backing up or dealing with very large DNN databases? How can they be trimmed down and optimized? Any help would be greatly appreciated. Thanks.

you should check your database for largest tables, in many cases, there are tables which need to cleaned up, e.g. eventlog (should contain up to only a few hundred entries), schedule history (same) and search tables (size depend on content and modules, but useful to rebuild from scratch periodically). Also consider reducing site log or use file logging and external log tools instead.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN