Maintenance Manual

Managing and Maintaining Servers 73
 The jobs that did not run successfully, will show a warning sign and you can expand the row to see the
reason of failure.
Sample job runs
Creating Backup Copies
Backups are critical in case of hardware failure. The following backup policy ensures that you won’t lose more
than one hour of data. SQL supports full recovery model and hence this policy is strongly recommended. When
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 active database
must be kept under 110 GB.
 Schedule archive jobs to run during off-peak hours to avoid database performance bottlenecks.
 Purge archived activities to create more available disk space.
Important: The Archive database is available only in installations that use the Standard Edition of
Microsoft SQL.