Create a database and write a report on it – 2 written pages + add tables and graphs from the 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:
1. Company Overview – Provide an overview of the company and its operations
2. 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.