It is well recognized that running a database requires two positions to be filled. One is the Applications Administrator. This person insures the data is entered correctly, trains the users, and deals with how the information is used. The other person is the database administrator. This is the person who deals with the technical aspects of the database. Although both of these responsibilities could reside in one person, often two people fill these roles. The ASP eliminates the need for the database administrator. Below is a list of the maintenance done on a regular basis to insure things are running correctly.

Reorganize data and index pages
Reorganizes pages with original amount of free space

Check database integrity
include indexes
attempt to repair any minor problems

Complete backup every day at 11:30 PM
Keep two days, spin to tape and delete

Transaction log backup every 4 hours
keep two days, spin to tape and delete.

The Transaction log truncates when it is backed up and wont get very big.

We can do a 'point in time restore' at any time.

Copyright © 2002 All rights reserved Kemp's Case Works, Inc.