Disaster Recovery

Instructor Information
Name: Sanjay Goel
Email: [email protected]
Phone: (518) 442-4925
Office Location: BA 310b, University at Albany, SUNY

Class Information

Date: March 23, 2007
Time: 9:00am - 4:00pm
Location: University at Albany, Earth Science Building, Room ES-B19
Credit(s): Professional Development (6 hours)

Resources

Website: https://www.albany.edu/~goel/classes/spring2007/pwsp/disasterrecovery
Syllabus: https://www.albany.edu/~goel/classes/spring2007/pwsp/disasterrecovery/DisasterRecoverysyllabus.pdf Readings:

Richard L. Arnold, Recovery from Sept. 11 Events Is Slow Process, Disaster Recovery Journal Available at: http://www.drj.com/special/wtc/drjwtcspecialh.pdf

LESSONS LEARNED FROM HURRICANE KATRINA: Preparing Your Institution for a Catastrophic Event, Available from http://www.fdic.gov/regulations/resources/lessons/index.html

Reference Books:

Guide to Disaster Recovery by Michael Erbschloe, Thomson Course Technology

Course Overview

This two-day workshop provides a broad introduction to modeling, design, and implementation of database applications using the relational model. It also provides students with a working knowledge of Structure Query Language (SQL) using Microsoft Access. The class will include several hands-on exercises in the laboratory for database design as well as SQL. The class will also discuss the architecture and implementation issues, such as, performance, management, concurrency, and recovery.

Course Format

The class is taught in an immersion format where the students spend a full day working on this subject. The class will involve lectures as well as short vignettes surrounding the material covered in the class. I believe that this is essential to ensure that the students are thinking critically about the subject rather than just gathering facts in the class only to lose them in a few weeks.

Course Prerequisites

None

Learning Objectives

Students should be able to:

1. Get Basic Knowledge of Disaster Recovery
2. Be able to design a Disaster Recovery Plan
3. Be able to recover lost data from a hard drive

Grading

Pass/Fail: Based on Attendance

Course Schedule

Time	Topics	Readings
	Introduction & Overview	Disaster Recovery Notes
9:30-10am	When Disasters Happen
10am-12pm	Disaster Prevention and Continuity Planning
Lunch Break
1-2pm	Developing the Plan	Data Storage & Backup Notes
2-3:30pm	Recovering Data (Knoppix/Helix - Autopsy)
3:30-4pm	Conclusion