Backups: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
 
(7 intermediate revisions by the same user not shown)
Line 6: Line 6:


== Centralized data Backup ==
== Centralized data Backup ==
They live on \\hsc1msfp0013\SHARED\WRHA_CCMED\Backup ([[M:\]])
Centralized_data.mdb and [[PHI.mdb]] live on an eHealth server and so are backed up by them ([[#eHealth file shares]]). We also created dated snapshot backups every time the [[data processor]] pulls data as part of [[vetting]] and then pushes it again. For details, see  
Centralized_data.mdb and [[PHI.mdb]] live on an eHealth server and so are backed up by them ([[#eHealth file shares]]). We also created dated snapshot backups every time the [[data processor]] pulls data as part of [[vetting]] and then pushes it again. For details, see  
* [[Pull down centralized data.vbs]]
* [[Pull down centralized data.vbs]]
Line 13: Line 11:
* [[Copy here only centralized data.vbs]]
* [[Copy here only centralized data.vbs]]


=== culling ===
=== Centralized backup locations ===
Pagasa has a reminder to manually cull the backups quarterly as follows because they had generated >100GB of files. Would be nice to automate eventually, but leaving for now. As agreed with Trish:
* for a '''month''', keep the '''latest file each day'''
* for a '''year''', keep the '''last file each month'''
* '''forever''', keep the '''last one per year'''
Following directories:  
Following directories:  
* M:\backup\Centralized_data
* [[M:\]]Backup\Centralized_data
* M:\Backup\PHI
* [[M:\]]Backup\PHI
* M:\Backup\TISS28
* [[X:\]]CCMDB\PHI\PHI_CSV_Archive


==== PHI .csvs ====
=== Retention ===
* X:\CCMDB\PHI\PHI_CSV_Archive
We only retain backups for a time. See [[Culling backups]] for details.
** delete all older than 1 year


==== Instructions ====
== eHealth file shares ==
For each of the above directories, delete all files that are older
All our file shares are backed up by eHealth. To restore any files missing from a file share contact the help desk. Their retention schedule as of 2019-12 is:
 
{| class="wikitable"
=== TISS28 ===
|-
TISS28 is not part of our backup process right now. OK for now, because backed up by eHealth, but for consistency we should start sending dated copies to \\hsc1msfp0013\SHARED\WRHA_CCMED\Backup like the rest of our core data.
|
| colspan="2" | Daily
| colspan="2" | Bi-Weekly
| colspan="2" | Monthly
|-
|| Data Category
|| Backup Type
|| Retention Period
|| Backup Type
|| Retention Period
|| Backup Type
|| Retention Period
|-
|| DEFAULT - ALL local drives (default excludes below data categories)
|| I
|| 4W
||  
||  
|| F
|| 6M
|-
|| File Shared
|| I
|| 4W
||  
||  
|| F
|| 12M
|-
|| Databases
|| I
|| 2W
|| F
|| 4W
||  
||  
|-
|| Virtual Machines
|| I
|| 4W
||  
||  
|| F
|| 6M
|}


I was going to add it the push/pull process but then realized that I am not at all sure that Pagasa doesn’t use TISS on one PC while in pull state on the other. So, we can’t be pulling TISS28 at that spot until we have worked out how Pagasa does this.
== Related articles ==
 
{{Related Articles}}
We talked the other day about changing Pagasa’s setup to use only one PC. This might be the time to re-visit that, too. So, likely Trish, Tina and Pagasa need to talk before I can integrate this.
 
Scheduled for 2015-May-25
 
== eHealth file shares ==
All our file shares are backed up by eHealth. To restore any files missing from a file share contact the help desk.


[[Category: Backup | *]]
[[Category: Backup | *]]
[[Category: IT Instructions]]
[[Category: IT Instructions]]

Latest revision as of 12:16, 2024 January 15

see also Category:Backup

Laptop

Centralized data Backup

Centralized_data.mdb and PHI.mdb live on an eHealth server and so are backed up by them (#eHealth file shares). We also created dated snapshot backups every time the data processor pulls data as part of vetting and then pushes it again. For details, see

Centralized backup locations

Following directories:

  • M:\Backup\Centralized_data
  • M:\Backup\PHI
  • X:\CCMDB\PHI\PHI_CSV_Archive

Retention

We only retain backups for a time. See Culling backups for details.

eHealth file shares

All our file shares are backed up by eHealth. To restore any files missing from a file share contact the help desk. Their retention schedule as of 2019-12 is:

Daily Bi-Weekly Monthly
Data Category Backup Type Retention Period Backup Type Retention Period Backup Type Retention Period
DEFAULT - ALL local drives (default excludes below data categories) I 4W     F 6M
File Shared I 4W     F 12M
Databases I 2W F 4W    
Virtual Machines I 4W     F 6M

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Backups&oldid=160667"