Re: [MBZ] OT MDB files
> One thing to note. If an SSD is in use and power is lost, your data is > probably going to be corrupted. Unless you are using an enterprise grade > drive. For critical data I trust only rotating magnetics. SSD's are fast, but they're cheap and sloppy now. You can't even find any technical specs on most of 'em. -- Jim ___ http://www.okiebenz.com To search list archives http://www.okiebenz.com/archive/ To Unsubscribe or change delivery options go to: http://mail.okiebenz.com/mailman/listinfo/mercedes_okiebenz.com
Re: [MBZ] OT MDB files
One thing to note. If an SSD is in use and power is lost, your data is probably going to be corrupted. Unless you are using an enterprise grade drive. Rick ___ http://www.okiebenz.com To search list archives http://www.okiebenz.com/archive/ To Unsubscribe or change delivery options go to: http://mail.okiebenz.com/mailman/listinfo/mercedes_okiebenz.com
Re: [MBZ] OT MDB files
Excel may be able to open or at least import data from an .mdb file. On Mon, Dec 4, 2023, at 09:31, dan penoff.com via Mercedes wrote: > No need to pile on over the backup issue. Like Jim, use multiple types > of media and multiple backup strategies. I had a catastrophic loss in > the late 90s that I learned my lesson on. I had backups, but like this > situation, I had legacy files that couldn’t be restored. > > I think .mdb is the file extension for Access, which is bad news, as > Access didn’t play nice with anything else that I can recall. > > -D > >> On Dec 3, 2023, at 12:08 PM, Jim Cathey via Mercedes >> wrote: >> >> That sucks, sucks, sucks, but only hammers home the lesson that you >> need to know your tools, and have strategies in place for protecting >> important >> data. Shit Happens, and that's no lie. For example, is a database the best >> tool for your job? I use a plain text-file system, which means zero >> dependence >> on any particular tool. I don't get database access, but then again I have >> no real >> need to run complex queries on the stored data. Mostly I just need a log, >> and I >> use grep to find things in it on occasion. It's been entirely satisfactory. >> >> Our family computing resources are protected by Time Machine (Apple), sent to >> a RAID storage server that itself has periodic rotating offsite/offline >> backups. It >> would take an asteroid strike or the equivalent to get it all, though I >> could ultimately >> lose the last quarter's data to a house fire or something. If I cared more >> I could exploit >> the cloud or something to get an additional layer of protection, and perhaps >> less exposure >> to loss. Or up the offsite update frequency. (Which reminds me, it's >> time...) >> >> At work we have multiple layers of backup in place, including some >> additional ones to >> protect the critical database from ransomware. The trickiest part in any >> loss scenario >> might be figuring out which recovery strategy (from the playbook) is the >> best one. >> Time to recover is a factor in a business that probably doesn't really apply >> to a private >> situation. >> >> If it's important you need to whip up some threat scenarios, and then design >> responses >> to them, and then implement. As a first rule of thumb, ALL your data should >> NEVER be >> on the same medium. That means backups absolutely need to go to a different >> device. >> And that's just the beginning. >> >> For those enamored of subscription-based cloud services, a big threat is the >> company >> going out of business. Do you have a response? >> >> -- Jim >> >> >> ___ >> http://www.okiebenz.com >> >> To search list archives http://www.okiebenz.com/archive/ >> >> To Unsubscribe or change delivery options go to: >> http://mail.okiebenz.com/mailman/listinfo/mercedes_okiebenz.com >> > ___ > http://www.okiebenz.com > > To search list archives http://www.okiebenz.com/archive/ > > To Unsubscribe or change delivery options go to: > http://mail.okiebenz.com/mailman/listinfo/mercedes_okiebenz.com ___ http://www.okiebenz.com To search list archives http://www.okiebenz.com/archive/ To Unsubscribe or change delivery options go to: http://mail.okiebenz.com/mailman/listinfo/mercedes_okiebenz.com
Re: [MBZ] OT MDB files
No need to pile on over the backup issue. Like Jim, use multiple types of media and multiple backup strategies. I had a catastrophic loss in the late 90s that I learned my lesson on. I had backups, but like this situation, I had legacy files that couldn’t be restored. I think .mdb is the file extension for Access, which is bad news, as Access didn’t play nice with anything else that I can recall. -D > On Dec 3, 2023, at 12:08 PM, Jim Cathey via Mercedes > wrote: > > That sucks, sucks, sucks, but only hammers home the lesson that you > need to know your tools, and have strategies in place for protecting important > data. Shit Happens, and that's no lie. For example, is a database the best > tool for your job? I use a plain text-file system, which means zero > dependence > on any particular tool. I don't get database access, but then again I have > no real > need to run complex queries on the stored data. Mostly I just need a log, > and I > use grep to find things in it on occasion. It's been entirely satisfactory. > > Our family computing resources are protected by Time Machine (Apple), sent to > a RAID storage server that itself has periodic rotating offsite/offline > backups. It > would take an asteroid strike or the equivalent to get it all, though I could > ultimately > lose the last quarter's data to a house fire or something. If I cared more I > could exploit > the cloud or something to get an additional layer of protection, and perhaps > less exposure > to loss. Or up the offsite update frequency. (Which reminds me, it's > time...) > > At work we have multiple layers of backup in place, including some additional > ones to > protect the critical database from ransomware. The trickiest part in any > loss scenario > might be figuring out which recovery strategy (from the playbook) is the best > one. > Time to recover is a factor in a business that probably doesn't really apply > to a private > situation. > > If it's important you need to whip up some threat scenarios, and then design > responses > to them, and then implement. As a first rule of thumb, ALL your data should > NEVER be > on the same medium. That means backups absolutely need to go to a different > device. > And that's just the beginning. > > For those enamored of subscription-based cloud services, a big threat is the > company > going out of business. Do you have a response? > > -- Jim > > > ___ > http://www.okiebenz.com > > To search list archives http://www.okiebenz.com/archive/ > > To Unsubscribe or change delivery options go to: > http://mail.okiebenz.com/mailman/listinfo/mercedes_okiebenz.com > ___ http://www.okiebenz.com To search list archives http://www.okiebenz.com/archive/ To Unsubscribe or change delivery options go to: http://mail.okiebenz.com/mailman/listinfo/mercedes_okiebenz.com
Re: [MBZ] OT MDB files
That sucks, sucks, sucks, but only hammers home the lesson that you need to know your tools, and have strategies in place for protecting important data. Shit Happens, and that's no lie. For example, is a database the best tool for your job? I use a plain text-file system, which means zero dependence on any particular tool. I don't get database access, but then again I have no real need to run complex queries on the stored data. Mostly I just need a log, and I use grep to find things in it on occasion. It's been entirely satisfactory. Our family computing resources are protected by Time Machine (Apple), sent to a RAID storage server that itself has periodic rotating offsite/offline backups. It would take an asteroid strike or the equivalent to get it all, though I could ultimately lose the last quarter's data to a house fire or something. If I cared more I could exploit the cloud or something to get an additional layer of protection, and perhaps less exposure to loss. Or up the offsite update frequency. (Which reminds me, it's time...) At work we have multiple layers of backup in place, including some additional ones to protect the critical database from ransomware. The trickiest part in any loss scenario might be figuring out which recovery strategy (from the playbook) is the best one. Time to recover is a factor in a business that probably doesn't really apply to a private situation. If it's important you need to whip up some threat scenarios, and then design responses to them, and then implement. As a first rule of thumb, ALL your data should NEVER be on the same medium. That means backups absolutely need to go to a different device. And that's just the beginning. For those enamored of subscription-based cloud services, a big threat is the company going out of business. Do you have a response? -- Jim ___ http://www.okiebenz.com To search list archives http://www.okiebenz.com/archive/ To Unsubscribe or change delivery options go to: http://mail.okiebenz.com/mailman/listinfo/mercedes_okiebenz.com
[MBZ] OT MDB files
Does anyone have any experience with Microsoft acess .mdb type files? Trying to recover my service records from this SSD crash. The program uses mdb files for the database and I have a clean file I saved off the HDD that appears to have all of the vehicles in it, but the fuel and service records only go up to 2021, which is when this file is from. On the SSD, that is where the currrent file and backups reside. I downloaded a data recovery program that lets you try it free to recover a certain number of files before you have to buy. This program found the file in question which is 9/2023 and recovered it. When I try to launch the program with this file as the data base, it appears to have errors of some sort and corrupted I assume. However after clicking thru the errors and getting into the program, this database file appears to have all of the fuel and service records up thru 9/2023 but appears to missing some of the vehicles. Does anyone know if there is a way to merge these 2 files together and possibly make one usable database? I have googled and it appears it might be possible but I have no experience using access and thought maybe one of you fold might? I have also been able to recover the auto backups it does, but when I try to access them it asks for a password. I have not set a password so I assume perhaps the software does it when backing up? No idea? I will email the vendor as ask them. ___ http://www.okiebenz.com To search list archives http://www.okiebenz.com/archive/ To Unsubscribe or change delivery options go to: http://mail.okiebenz.com/mailman/listinfo/mercedes_okiebenz.com