Sanjay Goel, School of Business, UAlbany

PH: (518) 442-4925
FX: (518) 442-2568
Email: goel@albany.edu

Business Administration 310b
1400 Washington Ave.
Albany, NY 12222

Warning! The navigation menu needs JavaScript to work.

On IE, click on the yellow bar and select "Allow Blocked Content". And then, select Tools --> Internet Options, click the Advanced tab, and check "Allow active content to run in files on my computer" under Security.

For Mozilla Firefox, click on Tools --> Options --> Content --> and check the enable JavaScript box.

If using the NoScript add-on, click on the icon at the bottom of the browser and select "Allow albany.edu".

Disaster Recovery

Instructor Information
Name: Sanjay Goel
Email: goel@albany.edu
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: http://www.albany.edu/~goel/classes/spring2007/pwsp/disasterrecovery
Syllabus: http://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:

Get Basic Knowledge of Disaster Recovery
Be able to design a Disaster Recovery Plan
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)	Data Storage & Backup Notes
3:30-4pm	Conclusion