Hi all,
Recently we have had a second user, so I put the database as a whole on a mapped drive on sbs 2011. Of course the first power cut crash and the database got corrupted so yes, splitting FO and BE now. I just kept together for ease of changes and edits but I will keep it split from now on as learned my lesson. I have Only 2 users and Data is around 50mb so not a big deal to give seperate front ends.
My main questions is, would a basic cheap NAS for around £200 with one enclosed and a 512gb ssd drive be suitable to host the backend access database or is it best to leave on the old sbs server? Or perhaps a seperate drive attached to the usb of the server? Unfortunately our server is so old it can sometimes run real slow, it’s only still in use as it does the dns and for Remote Desktop access, so I would prefer to run the back end database on a newer device with faster drive perhaps on ssd drive on a Nas of some sort as we have a very fast cat 7 network here?
many thanks
Recently we have had a second user, so I put the database as a whole on a mapped drive on sbs 2011. Of course the first power cut crash and the database got corrupted so yes, splitting FO and BE now. I just kept together for ease of changes and edits but I will keep it split from now on as learned my lesson. I have Only 2 users and Data is around 50mb so not a big deal to give seperate front ends.
My main questions is, would a basic cheap NAS for around £200 with one enclosed and a 512gb ssd drive be suitable to host the backend access database or is it best to leave on the old sbs server? Or perhaps a seperate drive attached to the usb of the server? Unfortunately our server is so old it can sometimes run real slow, it’s only still in use as it does the dns and for Remote Desktop access, so I would prefer to run the back end database on a newer device with faster drive perhaps on ssd drive on a Nas of some sort as we have a very fast cat 7 network here?
many thanks