Administrator's Guide

Managing databases 83
the recovery mode is set to full it is necessary to backup transactional logs periodically. Otherwise it may lead to
a disk space issue because of transaction logs growing indefinitely.
 Perform a weekly complete backup, daily differential backup, and hourly transactional log backups.
Archiving
Regular archiving helps to keep the size of the database manageable. The maximum size of the database should
be kept under 20 GB in most cases.
 Schedule archive jobs to run during your off-peak hours to avoid database performance bottlenecks.
 Purge archived activities to create more available disk space.
Applying Microsoft security patches and service packs
Microsoft releases security patches and service packs to plug vulnerabilities in the operating system and various
programs.
 Apply these patches after confirming their impact on the application.