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.