CCMDB data.mdb restore from Regional Server: Difference between revisions

← Older edit Newer edit →

@@ Line 10: / Line 10: @@
 == How to restore CCMDB_data.mdb ==
 # Make sure you are closed out of Access program
-# Check if the local backup is OK
+# Make a backup of the current ccmdb_data.mdb file
 ## Navigate to the <code>c:\ccmdb_data</code> directory, for example
 ### Click on '''{{Windows key}} + "E"''' key on your keyboard
 ### paste <code>c:\ccmdb_data</code> into the address bar and hit enter
-### '''rename the file ccmdb_data.mdb to ccmdb_data_corrupted.mdb''' (or steps further down will give errors)
+### rename the file ccmdb_data.mdb to ccmdb_data_pre_<the date>.mdb (e.g. ccmdb_data_pre_20200301.mdb)
-## double-click on '''"ccmdb_data_backup"''' (or '''"ccmdb_data_backup''.mdb''"''')
+# restore the backup from the [[Regional Server]] to the laptop
-##* if this opens you may have a good version, need to confirm:
+## double-click on the [[Regional Server]] shortcut on your desktop
-### double-click on '''table L_Log''' in the list one the left
+## navigate {{Regionalserver|data\''<[[Laptop identifier]] of this laptop>''}}
-### check if your newest entered record is in there
+## double-click [[data_to_local.bat]] and follow its instructions to copy the backup to your laptop
-## rename '''"ccmdb_data_backup.mdb"''' to '''"ccmdb_data.mdb"'''
-# if the local backup didn't work out, try the backup on the [[Regional Server]]
-## double-click on the [[Regional Server]] shortcut on your desktop, then navigate {{Regionalserver|data\''<[[Laptop identifier]] of this laptop>''}}
-## double-click on "ccmdb_data" / "ccmdb_data.mdb"
-### follow steps 2-4-... above to check if file is valid; '''even if not all data is here, this may be the best you got'''; if this file is also corrupted, work your way through the numbered backup files from newest to oldest until you find a good copy
-### copy the good file to your '''C:\CCMDB_data''' directory and make sure it's called [[CCMDB_data.mdb]] with no other numbers or words (if it's the un-numbered file you are copying you can just double-click [[data_to_local.bat]] and follow its instructions
 # open [[CCMDB.accdb]] from your desktop shortcut as usual
 # '''Email [[tech support]] that you did this''', and whether it fixed your problem. These instructions allow you to fix problems quickly when they happen, but we want to know if there are patterns of problems so we can prevent them in the first place.