ArcSDE team has a very good blog posting on best practices for maintaining an SDE geodatabase. A must read for all users who are involved with working and maintaining geodatabases.
Here is the link
(http://blogs.esri.com/Dev/blogs/geodatabase/archive/2008/04/03/Five-Best-Practices-for-Maintaining-an-Enterprise-Geodatabase.aspx)
