About  |  Contact Us  |  Register for Benefits  |  Login  |  View/Edit Your Profile  |  Consulting  |  Principal & Founder  |  Sponsorships  |  Legal & Privacy

  Home      Blog      Job Board      Community      Contribute      Vendor Listings      Search Site
  Employment  |  More With Less  |  Potpourri  |  Records  |  Reporting  |  Research  |  Revenue  |  Samples  | Systems  |  Web Sightings
 
  Data backup strategies. Systems
Overview | Know Your Backup Software | Devices & Media | Backup Types | Full Redundancy | Regular Backup Tasks | Reporting & Monitoring

Data Backup StrategiesReporting and Monitoring

The following are some suggested reporting and worksheet formats to help you monitor your backups.

 

Backup and Copy Window Worksheet
Purpose: Setting up your backup and copy window. Also list any batch jobs, pre or post backup sql or other tasks so you can accurately keep track of processing windows and available time windows. Very useful to develop this matrix especially if you have multiple servers databases, etc.
Frequency: Monthly or as required.
Distributed to: Internal, systems administrators, network support, backup operators.
 
Time: Production Server: Backup Server:
09:00 Export all tables  
10:00    
11:00 Copy table to backup server Copy tables from production server
12:00 Backup production database to tape Restore tables from copies
01:00    
02:00   Backup backup database to tape
03:00    
 
Monthly Record Counts
Purpose: Counts of records in related tables, run on a monthly basis. These should be summarized and graphed over time to monitor growth of tables and number of records, and to also ensure that records are not accidentally deleted. Helps plan network space growth, future network and records maintenance activities. Ideally stored in a table that retains a monthly snapshot.
Frequency: Monthly or as required.
Distributed to: Internal, systems administrators, network support.
 
 
  ↑  Top of Page  |  Samples Page  |  Sample Forms  |  Favorite Reports  |  Frequently Asked Questions  |  Glossary of Terms