asp.net - Can web app and database be hosted on different servers (remote and local)? -

i apologize right away if misuse right ask questions here. yet, being tyro in web development , asp.net beginner, need advice experts.

i have developed asp.net webforms application deploy remote hosting server. application queries , updates database due purpose of being document registration system. sold different institutions i've imagined following scenario: host app on same server institutions , have databases on different server or on multiple different servers. have considered option because data amount expands storage provided hosting companies may insufficient.

my question is: possible accomplish scenario , if yes risks , how should it?

thank much!

yes, normal way it. however, need fast network connection between web server , database server. need consider service level (ie percentage up-time) , how redundancy needed achieve that.

there's easy way , harder way achieve this.

the easy way host application in microsoft azure. fast implement , flexible.

you can host database in sql azure database, microsoft recommend new development. can scaled small (and low cost) powerful (more cost).

similarly web application can scaled. can scale vertically, making machine more powerful, , horizontally adding more machines.

for both database , web application, scaling can changed or down in few minutes.

the harder way host application on virtual machines. need lot of knowledge configure , maintain this. instance, might need configure sql server alwayson.

this screen picture shows how can select pricing tier web application hosted in microsoft azure. (prices in gbp.)

you should host web app , database in same data centre ensure there fast network connections between them. can make them belong same "resource group", tells azure work together.

this shows how can select level sql azure database. (prices in gbp.)

see microsoft azure > azure pricing: https://azure.microsoft.com/en-gb/pricing/