Backups

We are using two-tier backup schemes during data collection and again for the primary data repository.

PDA Backup

• see PDA manual backup using Sprite Backup
• see PDA automatic backup during Sync Synch

PDA restoring using Sprite Backup

• see: PDA restore using Sprite backup

Primary Data Repository (TMSX and MedTMS data) Backup

• seeTMSX MEDTMS Backup

Problems with the current system

• Pagasa can only “push” files to PCs that are logged on, leading people at the main office to not log off
• According to IT Policies patient data should not be stored locally on PCs due to security concerns
• Sharing drives on PCs is a security concern and should be avoided. eHealth is looking at prohibiting and preventing the practice.
• If we can’t use shared folders any more, we will have to change our data management process from a “push” by Pagasa to a “pull” from the network by everyone prior to running the program. This would need to be set up, and would be time consuming every time the program is used.
• Data at the data collector PCs is not being updated at all

Recommendation

• If the program could be changed so that the location from which to pull data is variable, we could put the data on the SAN. This way
• we would be in compliance having it off the PC
• we could have automatic off-site backups through the IT backup policy
• even without the backup policy, the data would probably be on the regional server at SBGH, and therefore even the live data would be off-site
• we would be able to keep the local installs on data collectors PCs up-to-date
• we would be able to continue to use a 1-step process to disseminate the data
• we would be able to eliminate local shares
• If we don’t want to trust IT with the backups, we could have back-up to a memory stick that could be kept in Trish’s office, detached from the PC to be safe from power surges and viruses. Since the server is at SBGH this should suffice as an off-site backup.

• concern re: memory stick. Easy to misplaceTOstryzniuk 17:39, 6 February 2009 (CST)

Additional Info Required

• process/batch file copying out data from Pagasa to other 4 PCs.
• what do the other batch files on Pagasa's PC do?

Backups

• SEE: Data processing backup

• will work on this next week. Friday at 1623.....long day. Time to stop. Will tidy up below once Pagasa provides further details. -- Pagasa & Trish. --PTorres 16:25, 6 February 2009 (CST)

• • List of backup batch files:
    • 1. CC_backup.bat
      2. MD_backup.bat
      3. Outputbackup.bat
      4. DataTwisterMDBtoSANS.bat
      5. DatatoTMP.bat?
      6. Importbackup (automatic - when PDA reader.exe is used. (also know as PDA uploader.exe)
      7. ANY OTHERS that we need to list here?--TOstryzniuk 17:32, 6 February 2009 (CST)

To SANS (X)from Pagasa's computer:

Trish moved this here from Data Processing Page. Will clean up once we get more detail from Pagasa.TOstryzniuk 17:37, 6 February 2009 (CST)

• • CCbackup.bat
  • Medbackup.bat
    • How often?
    • I do the back up everyday or if I did a lot of edits in a day.
    • What is included?
    • It includes the Registryx.dat,Pharmacy.dat,Apache.dat,Lab.dat and tiss.dat for ICU.
    • For Medicine Registryx.dat,Lab.dat,Apache.dat,ADL.dat,SAPSII.dat,SAPSXtra.dat and tiss.dat.
• To Pagasa's C drive from Output folder on Regional Server
  • Output backup.bat
    • How often?
    • Once a week is the plan but not always done.
    • Why is this back up done?
    • If we have a problem on TmpV2_1.mdb, TASKS.mdb and greensheet.mdb.
    • What is included in this backed up?
    • TmpV2_1.mdb, TASKS.mdb and greensheet.mdb, Pending.mdb.
    • where does this backup go?
      • Pagasa's C:\OutputBU
        • Important! Trish and Pagasa reviewed this backup today. Notice that as of August 26.08 the archived zip files cannot be opened anymore. Error message....etc. Pagasa noted that she got her new computer July 31.08. This backup last done in June. The next time she did this backup was Aug 26.08. From that point on, the zip archive cannot be opened.--PTorres 16:04, 6 February 2009 (CST)-- & Trish

To SANS from OUTPUT folder on Regional Server:DataToTmp.bat?? to X drive

• • DataTwister mdb to SAN.bat
    • how ofter?
    • I do this every week after I moved the DataToTmp.bat or if I do changes on TmpV2_1.mdb, TASKS.mdb or greensheets.mdb. This back up is for Julie.
    • It includes the TMPV2_1.mdb, TASKS.mdb, greensheets.mdb and Pending.mdb.

PTorres 15:28, 13 November 2008 (CST)