You should create a schedule for common maintenance tasks. The following table provides a sample and is not intended to supersede your current disaster recovery plan.
Task |
Interval |
---|---|
Update Antivirus |
Daily |
Update Patches Daily and Service packs |
Monthly |
Database Backup* |
Monthly |
Shrinking Transaction Log |
Monthly |
Index Defragmentation |
Monthly |
RDF Backup* |
Semi Annually |
Ghost or hard disk clone of application server* |
Semi Annually |
*This data should be stored in a safe location on another computer.