Server computer for Quickbooks

[brob]

Use an ssd for primary storage and a single hdd for local backup. The hdd should be about 6 - 10 times the size of a full backup to allow for a good history of backups. Being able to go back several weeks can, on rare occasions, be necessary.

 

Use a good backup package that will run scheduled backups and automatically manage storage utilization. Also do a regular (perhaps nightly) backup of the QuickBooks data set(s) off-site to a cloud store. There are a number of companies that offer backup software with integrate cloud backup with storage.

[Radium_Angel]

4 minutes ago, brob said:

cloud store.

Depending on their network bandwidth and data creation, this may, or may not, be possible.

[caner_saka]

16 minutes ago, Radium_Angel said:

(5) I'd then make nightly backups to one internal drive, weekly (or bi weekly, or whathaveyou based on (4) above) to the other drive, and copy the completed backup files to the NAS. This ensures maximum redundancy to the backups in the event of a disaster.

 

 

Ok so just to be clear, every night the back up will go on the internal drive, then the nas, then also at the end of the week there would be one more back up to another internal drive, then the nas, making for a total of 8 back ups on internal drives, 7 days separate on one drive, the whole week on another, and along the way all of this is replicated onto the nas daily?

Also I figure raid 1 is a good option as according to tech quickie its the best for redundancy I guess

Edited April 15, 2020 by caner_saka
Mentioning raid

[Radium_Angel]

5 minutes ago, caner_saka said:

Ok so just to be clear, every night the back up will go on the internal drive, then the nas, then also at the end of the week there would be one more back up to another internal drive, then the nas, making for a total of 8 back ups on internal drives, 7 days separate on one drive, the whole week on another, and along the way all of this is replicated onto the nas daily?

Also I figure raid 1 is a good option as according to tech quickie its the best for redundancy I guess

I'd personally use RAID 5, but it depends on the amount of data you are creating.

Otherwise, yes, you are correct, nightly backup to the internal drive, weekly backup to the other internal drive, and both backups written to the NAS.

This way you always have a backup somewhere, and data loss is kept to a minimum.

 

[caner_saka]

3 minutes ago, Radium_Angel said:

I'd personally use RAID 5, but it depends on the amount of data you are creating.

Otherwise, yes, you are correct, nightly backup to the internal drive, weekly backup to the other internal drive, and both backups written to the NAS.

This way you always have a backup somewhere, and data loss is kept to a minimum.

 

https://www.newegg.com/seagate-barracuda-st1000dm010-1tb/p/N82E16822184830?Item=9SIA65EB7V7213&Description=hdd&cm_re=hdd-_-22-184-830-_-Product

 

So four of these in a nas would work and I would ideally set it up in a raid 5 array, and internally I would put two similar or maybe(?) the same disk in the build since its only for backup and the rest would just be software, backing up through quickbooks and through the network, and maybe if it's not too complicated best to somehow get the nas offsite and hook up the network like that which would be a whole other deal i'm not sure about. Also I'm not 100% sure of the current back up size but according to that I can adjust the hdd size, but I doubt its too much.

 

Again, thank you very much for you help, I kinda feel like a little kid who needs someone holding my hand through this but I'm learning a lot.

[Radium_Angel]

12 minutes ago, caner_saka said:

https://www.newegg.com/seagate-barracuda-st1000dm010-1tb/p/N82E16822184830?Item=9SIA65EB7V7213&Description=hdd&cm_re=hdd-_-22-184-830-_-Product

 

So four of these in a nas would work and I would ideally set it up in a raid 5 array, and internally I would put two similar or maybe(?) the same disk in the build since its only for backup and the rest would just be software, backing up through quickbooks and through the network, and maybe if it's not too complicated best to somehow get the nas offsite and hook up the network like that which would be a whole other deal i'm not sure about. Also I'm not 100% sure of the current back up size but according to that I can adjust the hdd size, but I doubt its too much.

 

Again, thank you very much for you help, I kinda feel like a little kid who needs someone holding my hand through this but I'm learning a lot.

Sounds about right, all depends on how much data is created at night.

But you are all good, everyone has to start somewhere. We're here for you.

[brob]

RAID 5 is a very poor choice when using drives over 1TB. Rebuild times can run a day or more and while rebuilding is in progress another error will result in the loss of all data. Much better to use something like RAID 10.

[caner_saka]

5 hours ago, Radium_Angel said:

Depending on their network bandwidth and data creation, this may, or may not, be possible.

I was discussing options with the buisness and was curious, if a NAS is offsite, wouldn't the speeds be the same as a cloud based platform? They seem to be pushing more toward online cloud but I'm not sure. What would be the pros vs cons of the physical hdds and nas approach vs cloud?

[Radium_Angel]

12 hours ago, caner_saka said:

if a NAS is offsite, wouldn't the speeds be the same as a cloud based platform?

By and large.

12 hours ago, caner_saka said:

nas approach vs cloud?

I distrust "the cloud" because your data is hosted on someone else's servers. You are not in control of what happens (or who has access....) to said cloud server.

With a NAS, you are in control, but you are also responsible if the NAS fails.

 

Either of those options all depend on the amount of data being created, and how fast your internet is. Something only you know.

 

[brob]

The advantage of using a commercial cloud it that they typically offer enterprise level protections.

 

The downside is that they are bigger targets.