News and backup: Difference between revisions
Ttenbergen (talk | contribs) m Text replacement - "ccmdb.mdb" to "ccmdb.accdb" |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 6: | Line 6: | ||
The following are the '''minimally required news and backups''' and their reasons: | The following are the '''minimally required news and backups''' and their reasons: | ||
# at '''beginning of collection with a laptop''' before data entry | # at '''beginning of collection with a laptop''' before data entry | ||
#*this ensures that you have the newest version of the program | #*this ensures that you have the newest version of the '''program''' and '''any internal data changes (e.g. dropdowns, cross-checks)''' | ||
# when the email about the [[Cognos]] data arrives | |||
#* this ensures that you have the newest version of the '''Cognos data''' | |||
# at '''end of collection day with a laptop''' (whether you send or not) | # at '''end of collection day with a laptop''' (whether you send or not) | ||
#* very rarely things go wrong during sending; making a backup just before sending means we would be able to restore you to that version if sending corrupts your data | #* very rarely things go wrong during sending; making a backup just before sending means we would be able to restore you to that version if sending corrupts your data | ||
| Line 14: | Line 16: | ||
#* again, this gives the main office data to review in case something went wrong with the send. | #* again, this gives the main office data to review in case something went wrong with the send. | ||
You can additionally back up mid day. In theory you can do this as frequently as you want, but there are draw backs: we only keep the last | You can additionally back up mid day. In theory you can do this as frequently as you want, but there are draw backs: we only keep the last 40 backups, so if you back up 10 times a day we only have 2 days of backups for you. So, if we found out that we want to know something that happened last week, then if you did 10 a day we would no longer have the data, but if you did 3 a day, we usually would still have the data. So, be reasonable in your backup frequency. | ||
==Importance of backup to REGIONAL SERVER== | ==Importance of backup to REGIONAL SERVER== | ||
| Line 31: | Line 33: | ||
* [[backup.bat]] | * [[backup.bat]] | ||
** back up to local backup directory c:\ccmdb_data\ccmdb_backups w 20 versions of [[CCMDB_data.mdb]] | ** back up to local backup directory c:\ccmdb_data\ccmdb_backups w 20 versions of [[CCMDB_data.mdb]] | ||
** back up to server w | ** back up to server w 40 versions of [[CCMDB_data.mdb]] to the regional server | ||
** check if there is a file [[Regional Server]]\Programs\<hosp>_<ward>\ccmdb.accdb; if so, | ** check if there is a file [[Regional Server]]\Programs\<hosp>_<ward>\ccmdb.accdb; if so, | ||
** '''move''' the file from the regional server to c:\ccmdb_'''program''' | ** '''move''' the file from the regional server to c:\ccmdb_'''program''' | ||
| Line 57: | Line 59: | ||
== Testing News and Backup == | == Testing News and Backup == | ||
After initial setup test that the backup works: | After initial setup test that the backup works: | ||
* open and close | * open and close [[CCMDB.accdb]] to update date stamp of file on the client laptop | ||
* execute the News and Backup batch file to perform the process | * execute the News and Backup batch file to perform the process | ||
* check that | * check that [[CCMDB.accdb]] file with new stamp is on c:\ccmdb_data\ccmdb_backups | ||
* check that | * check that [[CCMDB.accdb]] file with new stamp is on [[Regional Server]]/data/<hsp>_<ward> | ||
== Information about the batch files == | == Information about the batch files == | ||
| Line 74: | Line 76: | ||
== Error checking == | == Error checking == | ||
Just do your backups and assume they work, there is no need for collectors to routinely check that the backups to the regional server are working. [[Data Processor]] in Main office checks regularly that backups are being done, so if backups are not making it to the regional server we will let you know. | Just do your backups and assume they work, there is no need for collectors to routinely check that the backups to the regional server are working. [[Data Processor]] in Main office checks regularly that backups are being done, so if backups are not making it to the regional server we will let you know. | ||
== Related articles == | == Related articles == | ||
| Line 81: | Line 81: | ||
[[Category: Batch Files]] | [[Category:Batch Files]] | ||
[[Category: Data Backup Dependencies]] | [[Category:Data Backup Dependencies]] | ||
[[Category: Backup]] | [[Category:Backup]] | ||