Periodic Reboots and other maintenance of server/DB?

Hi All,

We are in the process of migrating from E9 w/ Progress to E10 w/ Microsoft SQL. In E9 tech support told us we should be rebooting servers weekly, truncating the BI of the DB periodically, performing a dump and load periodically, etc. As we transition to E10 we’d like to know if a document exists that we can reference in regards to what preventative maintenance we should be performing?

I’d suggest looking through The Sys Admin Tech Ref.

edit: The Tech reference has step by step instructions for setting up maintenance plans like backup and rebuilding indexes.