saving SQL server 2012 databases on the web

fmichail
fmichail used Ask the Experts™
on
I need a reliable way to host a set of MS SQL server 2012 databases and can access them through an IP address. I already have a host, however, it costs me to add any SQL database to the site, and my site is basically used to host the databases of what will be my applications clients... Is there a cheaper way to save these database and use an IP address(s) to access them in the web?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Scott FellDeveloper & EE Moderator
Fellow 2018
Most Valuable Expert 2013

Commented:
There are different version.  If you have a very small app you can use Express and that is free. Otherwise, many hosting services can sell you the Web edition and that can run from $35 to $70 per month.  If you are on a VPS or Dedicated hosting service, then you can have as many databases as you wish for that price.

If you are on a shared hosting service where you are spending $20 per month or in that neighborhood, then allowing you to have a limited amount of databases sounds right. However, those databases will be on a shared server with a thousand others and may not have the best performance.

Check out using Azure to host your data https://azure.microsoft.com/en-us/

What is it you are expecting to pay?

Author

Commented:
Thanks Scott for the fast answer,

I am now using the shared hosting, and I have absolutely no performance issues and I am satisfied with it, the only problem is that I have to add $10/month for each additional database (databases are not that big... in MB sizes) and my application needs to have one database per customer... what I dream of is to get a shared host which limits the total storage, but not the number of databases... If that is not possible, I will have no option but going to the VPS option.

I checked with Azure, and because of my zero experience with the cloud (at least at the moment) I could not get a clear answer, and it sounded like I have to change all my development environment which I am not ready for... So I am not enthusiastic about it.

Any further help, Scott?
Developer & EE Moderator
Fellow 2018
Most Valuable Expert 2013
Commented:
>  what I dream of is to get a shared host which limits the total storage, but not the number of databases

I used to use NewTek a long time ago. This is how they work https://www.newtekwebhosting.com/asp-net-web-hosting/

If you are going to have a lot of clients, I would suggest getting into the VPS or Dedicated hosting if you do not feel comfortable with Azure. I have used https://www.liquidweb.com for a long time and been very happy with everything and especially support.  Be prepared to pay $250 to $350 per month and get at least 8 gigs of RAM if using the VPS. Dedicated starts at 16 gigs of RAM and that will be plenty for small apps.

I do think it will be worth exploring Azure. However, SQL Server on Azure is not exactly the same as a local hosted but for web, you should be able to make an easy transition.  You can continue using your web host for your apps, but use Azure for the db and scope the IP for the DB to only run from your web host's IP.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Thanks Scott,
I visited link you provided for asp.net hosting, and found it is extremely limited (SQL space is 800 MB... this is too small for me). I appreciate your help, and Explanation of the options that I was not aware of... and I think that is all what I needed to know, and I will start investigating all the options that you mentioned. . Thanks again

Author

Commented:
Thanks a lot Scott for the help and guide.
Scott FellDeveloper & EE Moderator
Fellow 2018
Most Valuable Expert 2013

Commented:
I agree on the space. They do allow you to pay for extra space. However, if you start adding up the cost by space or numbet of databases, you will find the break even point for vps or dedicated is close.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial