News and backup: Difference between revisions
TOstryzniuk (talk | contribs) →How often should you run News and Backup?: New and backup - Staff please review |
Ttenbergen (talk | contribs) m Text replacement - "[[Category: " to "[[Category:" |
||
| (7 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 26: | Line 28: | ||
The "'''News and Backup'''" batch file is a batch file on each '''laptop''' which does the following: | The "'''News and Backup'''" batch file is a batch file on each '''laptop''' which does the following: | ||
* [[batstart.bat]] | * [[batstart.bat]] | ||
** sets the [[Laptop | ** sets the [[Laptop identifier]] | ||
** checks if there is a newer version of [[backup.bat]]; if so, it downloads it | ** checks if there is a newer version of [[backup.bat]]; if so, it downloads it | ||
** calls [[backup.bat]] | ** calls [[backup.bat]] | ||
* [[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. | ** 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''' | ||
** open the wiki to [[Log]] to show what has changed | ** open the wiki to [[Log]] to show what has changed | ||
** copy log file CCMDB_backup_log.txt to the corresponding [[Regional Server]]\data\<[[Laptop identifier]]>; this log would show you when people have run news and backup and if there were errors. | |||
== Setting up the file on a laptop == | == Setting up the file on a laptop == | ||
If the laptop is set up according to [[Laptop Setup]] then the batch files and shortcuts will be copied down as part of the process. | If the laptop is set up according to [[Laptop Setup]] then the batch files and shortcuts will be copied down as part of the process. | ||
* | *The only thing to do locally would be to [[#Edit parameters for identifier]]. | ||
=== Edit parameters for | === Edit parameters for identifier === | ||
# right-click the news-and-backup shortcut and click "edit" | # right-click the news-and-backup shortcut and click "edit" | ||
#* '''Don't double-click''' because that would run the file | #* '''Don't double-click''' because that would run the file | ||
#* [[File:News and backup context menu.png | 150px]] | #* [[File:News and backup context menu.png | 150px]] | ||
# go to the line that starts with "set ml=", should be around line 12 | # go to the line that starts with "set ml=", should be around line 12 | ||
# change the "somewhere" to the [[Laptop | # change the "somewhere" to the [[Laptop identifier]], i.e. your directory on the regional server, e.g. HSC_H4 | ||
#* don't add spaces | #* don't add spaces | ||
#* make sure it's the directory used for the [[Laptop | #* make sure it's the directory used for the [[Laptop identifier]], for legacy reasons this might not be the main ward now collected on | ||
# menu file save, menu file close | # menu file save, menu file close | ||
#* [[File:News and backup edit menu.png | 400px]] | #* [[File:News and backup edit menu.png | 400px]] | ||
| Line 56: | 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 67: | Line 70: | ||
== Updating the file == | == Updating the file == | ||
BatStart.bat looks for an update to backup.bat in regional server\programs\< | BatStart.bat looks for an update to backup.bat in regional server\programs\<[[Laptop identifier]]>; that file will replace the local one. | ||
Make sure [[Batstart.bat#Log]]/[[Backup.bat#Log]] is updated with any changes. | Make sure [[Batstart.bat#Log]]/[[Backup.bat#Log]] is updated with any changes. | ||
| Line 74: | Line 77: | ||
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}} | |||
[[Category:Batch Files]] | |||
[[Category: Batch Files]] | [[Category:Data Backup Dependencies]] | ||
[[Category: Data Backup Dependencies]] | [[Category:Backup]] | ||
[[Category: Backup]] | |||