School of Medicine

As explained in the previous section, it is vital that backup copies be kept. Magnetic tapes are normally used for this, as they are cheaper than disks and can easily be taken to a safe location away from the School of Medicine.

Critical SOM services are backed up by the tape systems and tapes are kept 4-5 weeks.  We do not backup for archival purposes, only for system disaster recovery.  We will restore file and database data if it's within this 4-5 week window.  We will not restore mailboxes for the sole purpose of retrieving a deleted email message. These include

Schedule and rotations for the backups

• Incremental backups (daily backup of files that have changed) occur Monday thru Friday starting between 8:15pm and 11:15pm.  Incremental tapes tend to  get overwritten each week since the full weekend backups are more current than the previous week's daily backups.
• Full Weekly backups occur early Saturday morning starting 3am and continue through out the weekend.  Full backups are overwritten once a month.
• System State Backups occur every weekend on Sunday's starting at 3:15pm.
• SQL Database servers are full backups each time.
• The Exchange Cluster M-F is backed up to the Scott Hall SAN (disk-based backup on the G drive) and the weekend job is backed up to the Dell LTO array.  In addition, the Exchange partitions have a mirror set on the C&IT SAN and Scott Hall SAN in which the snapshots (resyncing & breaking of mirrorsets) occur.  The C&IT snapshots occur every 4 hrs and the Scott Hall snapshot occurs once a day.  Due to the Scott Hall SAN performance, the Scott Hall snapshots do not all occur at the same time and the time varies depending on the server.

File systems backed up

SoM Exchange Cluster Servers Job (Mon-Sat, Full) (Weekend to to Dell LTO, Daily to SAN)

• Med-Core03-MS1 Exchange Information Store
• Med-Core03-MS2 Exchange Information Store
• Med-Core03-MS3 Exchange Information Store
• Med-Core03-MS4 Exchange Information Store
• Med-Core03-MS5 Exchange Information Store

SoM Exchange Front-End Servers Job (Transaction Log backups M-F, Full on Weekends) (to Dell LTO)

• Med-Core01A Exchange Information Store
• Med-Core01B Exchange Information Store

SoM Servers Batch 1 Job Mon-Fri Inc & Sat Full to Dell LTO (SQL DBs always Full backup)

• Med-App06\D:
• Med-App15\D:
• Med-DB01 Microsoft SQL Database Server Cluster
• Med-DB01-VS2\INST1 Microsoft SQL Database Server Cluster
• Med-DB03 Microsoft SQL Database Server
• Med-DB05 Microsoft SQL Database Server Cluster Instance
• Med-DB05-EMR FileServices Data Drive (S:)
• Med-DB05-DEV\EMRDEV Microsoft SQL Database Server Cluster Instance
• Med-FMRE01 Microsoft SQL Database Server
• Med-FMRE01 FileServices Data Drive (D:, E:)

SoM Servers Batch 2 Job Mon-Fri Inc & Sat Full to Dell LTO (SQL DBs always Full backup)

• Med-App03 Data Drive (D:)
• Med-App08 Data Drive (D:)
• Med-Ceca01 FileServices Drive (D:)
• Med-Core02S FileServices Shared Folder Drives (I: & S:)
• Med-Core02U FileServices User Folder Drives (U: aka H drive)
• Med-DHCP01 System Partition (DHCP records)
• Med-PSBASQL Microsoft SQL Database Server
• Med-PSBASQL FileServices Data Drive (D:)
• Med-Web01 Data Drives (E: & F:)
• Med-Web02 Microsoft SQL Database Server (all databases except WebXM and CMS300Sample)
• Med-Web03 Data Drive (E:)

SoM Servers Batch 3 Job Mon-Fri Inc & Sat Full to Adic DLT (SQL DBs always Full backup)

• Med-Ingenix Data Drives (D: & E:)
• Med-App02 Data Drive (D:)

SoM Servers Batch 4 Job Weekly(to ADIC DLT)

• Med-Cognos Microsoft SQL Database Server

SoM Servers Batch 5 Job Mon-Fri Inc & Sat Full to Dell LTO

• Atharv /usr/local/*.*
• Kanga /
• Med-Fwmanager /*.* (except /proc /tmp /lost+found /initrd /lib /mnt /var/tmp /usr/netscreen.org /var/run)
• Med-Web04 /var /etc /home /root /opt/tomcat5.0.28
• MSS /var/named /opt/ipf /etc/opt/ipf /var/adm /var/log
• Oracle /oracle /backup-partition
• Roo /var/www/html /var/www/securehtml /usr/local /etc /root (except var/www/html/os/)

SoM Server Weekly System States job (System States and items that rarely changes from one day to the next.)

• eeyore.med.wayne.edu (SoM email router)
• Med-App01 System State, C drive
• Med-App02 System State, C drive
• Med-App03 System State, C and D drives
• Med-App05 System State and C, D and E drives.
• Med-App06 System State, C drive
• Med-App07 System State, C drive
• Med-App08 System State, C drive
• Med-App09 System State, C and D drives and LiveComm RTC SQL Database
• Med-App10 System State, C drive
• Med-App11 System State, C and D drive and SQL Database (Blackberry configs)
• Med-App13A System State, C drive
• Med-App13B System State, C drive
• Med-App14 System State, C drive
• Med-App15 System State, C drive
• Med-Backup01 System State, C, D and E drives
• Med-Ceca01 System State, C drive
• Med-Ceca02 System State, C & D drives
• Med-Cognos System State, C drive
• Med-Core01A System State, C drive
• Med-Core01B System State, C drive
• Med-Core02A System State and C drive
• Med-Core02B System State and C drive
• Med-Core03 System State
• Med-Core03A System State and C drive
• Med-Core03B System State and C drive
• Med-Core03C System State and C drive
• Med-Core03D System State and C drive
• Med-Core03E System State and C drive
• Med-Core03F System State and C drive
• Med-Core04 System State and C drive
• Med-DB01A System State and C drive
• Med-DB01B System State and C drive
• Med-DB01C System State and C drive
• Med-DB03 System State and C drive.
• Med-DB04 System State and C drive and SMS SQL Database
• Med-DB05A System State and C drive
• Med-DB05B System State and C drive
• Med-DHCP01 System State and C drive
• Med-EMR01 System State and C and D drives
• Med-EMR02 System State and C and D drives
• Med-EMR03 System State and C and D drives
• Med-EMR04 System State and C and D drives
• Med-EMR05 System State and C and D drives
• Med-EMR-INT1 System State and C and D drives
• Med-EMR-INT2 System State and C and D drives
• Med-EMR-Spare System State and C and D drives
• Med-FMRE01 System State and C drive
• Med-Ingenix System State and C drive
• Med-PSBASQL System State and C drive
• Med-SMS01 System State and C and D drives
• Med-TW01 System State and C drive
• Med-TW02 System State and C drive
• Med-Web01 System State and C drive
• Med-Web02 System State and C drive
• Med-Web03 System State and C drive

Systems awaiting production status notification before increasing backup service protection

• Med-Cognos
• Med-TW01 (may not be needed)

Robotic Libraries on Med-Backup01

Dell LTO Tape Array

• 0001-0008 Med Full Weekend - Week 1
• 0009-0016 Med Full Weekend - Week 2
• 0017-0024 Med Full Weekend - Week 3
• 0025-0032 Med Full Weekend - Week 4
• 0033-0040 Med Full Weekend - Last Week
• 0041-0042 Med System States
• 0043-0045 Med Monday Incrementals
• 0046-0048 Med Tuesday Incrementals
• 0049-0052 Med Wednesday Incrementals
• 0053-0056 Med Thursday Incrementals
• 0057-0060 Med Friday Incrementals

ADIC DLT Tape Array

• 0001-0005 Med Full Weekend B3 - Week 1
• 0006-0010 Med Full Weekend B3 - Week 2
• 0011-0015 Med Full Weekend B3 - Week 3
• 0016-0020 Med Full Weekend B3 - Week 4
• 0021-0025 Med Full Weekend B3 - Last Week
• 0026-0030 Med Daily Batch 3 - Mondays
• 0031-0035 Med Daily Batch 3 - Tuesdays
• 0036-0040 Med Daily Batch 3 - Wednesdays
• 0041-0045 Med Daily Batch 3 - Thursdays
• 0046-0050 Med Daily Batch 3 - Fridays