I currently have three work stations connected to a PC, that is acting like a File Server for my SQL Database for ACT2012 (by Sage) and my Quickbooks Accounting.
What I am finding, from my staff, is that it is very slow at time when accessing the files on ACT or clearing an activity and so for. I also at times have to access the database and files remotely. I am currently using LogMeIn Pro.
I am trying to find the best cost effective solution. I was told that if I purchase a VPS it would be liking having my own Server write in the heart of the office. I then would also be able to access the applications remotely and have faster response times.
I have searched all over the internet and I can't seem to understand what VPS is, apart from the fact it is a huge server partitioned into separate servers. It appears from the information on the web, VPS is only good for web hosting where a great deal of browers access the site.
I don't just want VPS to host my websites. I am very happy with my current web-hosting companies that are currently hosting 4 of my business websites.
I am just unsure as to whether a VPS purchase will cure my problem. If I was to purchase a VPS, would this be like a real Server, in the sense that I could load the databases of the ACT and Quickbooks, have my staff access the databases, do their emailing, have permission based folders, that allow staff to access the folder based on permissions allowed etc, etc.
If this is what VPS does, then great, but my concern would be, that wouldn't the speed of the accessing be determined to the internet connection of the office building or the USB Wireless device on a laptop that is connected to the internet.
Oh dear me, someone please help me understand what a VPS is meant to be used for, how it is used or what is the best option for me at work?