saving SQL server 2012 databases on the web

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?
fmichailAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
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?
0
fmichailAuthor 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?
0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
>  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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

fmichailAuthor 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
1
fmichailAuthor Commented:
Thanks a lot Scott for the help and guide.
0
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.