Database Maintenance Specifications

Create a database and write a report on it – 2 written pages + add tables and graphs from project on top of them. Develop a maintenance and DR Plan for a selected company. You are the database administrator so the document should outline all key areas that would provide the company with a detailed outline for ongoing maintenance and in event there is a disaster.

Areas of Focus:

Company Overview – Provide an overview of the company and its operations

Database Maintenance Specifications:

  • Database Environment
  • Users/Permissions
  • Storage Hardware Configuration
  • Governance and Regulatory compliance
  • Backup and Recovery Measures
  • Data Availability Plan:
  • Cluster vs log shipping
  • Database Performance Plan
  • Database Integrity Plan B checking
  • Memory Usage
  • Data monitoring
  • Disaster Recovery Plan

**Search the internet for examples of DR plan templates based on your research, select a DR template to complete to add to your project.