How to handle database failure

TerryJC · Post by **TerryJC** » 14/09/2020, 14:53

I have a nearly new 4 GB one made by TDK or a fairly old 16 GB one made by SanDisk.

Let me know which one you want and I'll drop it off at WMT tomorrow morning (I have to go in anyway to drop off a couple of outstanding Expenses forms).

hamishmb · Post by **hamishmb** » 14/09/2020, 15:23

Whichever one is less useful to you I would say. Either will be plenty big enough.

I will be back in soon to complete my pentesting so just let me know where you put it and I'll plug it into the NAS box.

TerryJC · Post by **TerryJC** » 14/09/2020, 15:27

I'll bring the smaller (and newer) one then.

hamishmb · Post by **hamishmb** » 14/09/2020, 19:59

NB: Don't worry about this. I'm not coming in to install this due to the local COVID spike. If you decide to go in anyway, might as well bring it, but otherwise don't worry. I can do remote backups and set up an automatic backup to the internal HDDs.

hamishmb · Post by **hamishmb** » 15/09/2020, 11:11

I have confirmed the USB stick is recognised and done a database backup. I shall sort out the rudimentary backup system soon.

hamishmb · Post by **hamishmb** » 22/09/2020, 13:00

Backup system is now working. I'll confirm on Monday morning if we have a backup, and if not I'll make a small change to fix it.

hamishmb · Post by **hamishmb** » 01/09/2022, 12:33

We did have a backup on Monday morning all those months ago, and the temporary backup system works fine except that the USB stick has been full for a very long time now. It doesn't matter much because the tick values are all wrong anyway due to the NAS box being unreliable.

While looking for other stuff, I have come across this thread again. Most of the work mentioned here never happened for a variety of reasons, and I'm no longer sure whether it is worth the effort, especially seeing as we plan to install a replacement NAS box that should fix any reliability issues.

EDIT: I'm also thinking the time and effort required to implement this solution is probably more of a problem than the financial cost of a new NAS box if a failure were to occur.

Thoughts?

TerryJC · Post by **TerryJC** » 01/09/2022, 13:23

I agree.

(The quicker we get the agreed jobs done, the quicker that Penri can justify the costs for a new NAS Box.)

hamishmb · Post by **hamishmb** » 01/09/2022, 13:55

Okay then, I'll shelve this idea and add it to my "nice-to-haves" list. Agreed that also the existing jobs take priority.

Wimborne Model Town Projects Forum

How to handle database failure

Re: How to handle database failure

Re: How to handle database failure

Re: How to handle database failure

Re: How to handle database failure

Re: How to handle database failure

Re: How to handle database failure

Re: How to handle database failure

Re: How to handle database failure

Re: How to handle database failure