Hi Bec, 1. There is no difference between SQL Server Express and any full version. You just restore your database or run your setup scripts from the Express version to the hosted one. Both the shared hosters mentioned in my previous post allow this with no problems. It is also possible to place your .mdf file in the App_Data folder of your application - however this is not an industrial strength solution.
2. Most shared hosters allow you to set permissions on various folders so your applcation can upload or download files easily. However you need to read the terms and conditions carefully as it may not be allowed in some cases. I have hear of a number of hosters who have shutdown websites with no warning saying "you contravend our terms and conditions" hence wrecking the business of he application provider. It's definitely a risk that must be managed. Also don't forget to address backup - assuming your hosting provider can vanish overnight is a good place to start. Regards ..... Mark Jarzebowski Director Software Engineering Business Model Systems (Victoria) Pty Ltd Kew Victoria www.bms.com.au On Tue, Apr 12, 2011 at 4:44 PM, Bec Carter <[email protected]> wrote: > G'day all! > > Sorry to hijack this thread but my question is related. > > 1) I am working on a site with a sql server express backend. What > options do I have for hosting such a thing? I know lots of hosting > providers offer SQL Server full (not express) but Im wondering what > restrictions they got when it comes to size. I had a look at > StudioCoast and some others but the space they offer seems small like > 40gb. > > 2) what about users uploading files and storing them to disk? Do > hosters even let apps upload files and store them on disk or will they > need to go into the database? and do they enforce size limits? > > Cheers, Bec > > > On Mon, Apr 4, 2011 at 4:10 PM, Corneliu I. Tusnea > <[email protected]> wrote: > > I'm also on www.web24.com.au with my own physical servers (2x150Gb in > Mirror > > + 1x 450Gb). > > Once you get to 80-100Gb of data you kind of expect or hope to get some > > income so $1000 or $2000 a year is not that much anymore. > > Plus in that moment if you have the traffic you'll start getting charges > > If you want just images/videos and they are all public drop them behind > > Amazon and run your site somewhere else. > > If you want to be ready to fly go Azure (they also have a CDN which is > not > > expensive) or Rackspace virtual servers or GoGrid. > > If you don't care about location I *highly* recommend Giga Hosting: > > http://www.giga-hosting.biz/?show=server > > e149/month for a server with 6x3.2Gb i7 + 80Gb SSD for primary site and > 2Tb > > HDD for storage + 100Mbp/s unlimited traffic (via 2x10Gb/s connections). > > It's fast. It's bloody fast. And cheap. That's like $200/month. > > We used to run Facebook games hosted by these guys (we had a custom > > configuration with 10,000rpm Velocity drives) and man it was delivering. > > Super high spikes of traffic and db writes like I've never seen before. > > Corneliu. > > > > > > > > On Sat, Apr 2, 2011 at 11:18 AM, Mark Jarzebowski <[email protected]> > wrote: > >> > >> Hi Tom, > >> > >> domaincentral.com (US servers Aust company) > >> > >> crazydomains.com.au (Australian servers) > >> > >> Both offer "unlimited" disk space in a shared hosting environment with > >> ASP.NET <http://asp.net/> and SQL Sever support. > >> > >> I use both for a range of applications and while I would not count on > >> using 1000Tb of space they both work reasonably well for smallish apps > (<200 > >> users). Both are very cheap (less than $200pa). > >> > >> If you need industrail strength hosting with lost of disk space try > >> esxhosting.com.au > >> They offer windows 2008 VPS with remote desktop control and the ability > to > >> expand to huge amounts of disk space. One of my apps is projected to > grow to > >> 10Tb of sapce and they can handle that with ease on thier SANs. > >> > >> I use esxhosting and it works very well. Prices are very > competitive with > >> other VPS providers (Azure and Amazon also) and the servers are based > >> in Sydney. you can expad and contract your space (and cost) very quickly > and > >> easily. > >> > >> I also use www.web24.com.au who can provide huge amounts of disk and > >> server resources from their Melbourne data centre. However beyond about > 80Gb > >> of space you need to lease physical servers which require substantial > >> committment and $$$. But you get a high quality service. > >> > >> Another important consideration is the financial strength of your > hosting > >> provider. What hasppens to you business if they go broke or out of > business. > >> In this area I think Azure and Amazon (and Google) win hands down. > >> > >> Regards ..... Mark Jarzebowski > >> Director Software Engineering > >> Business Model Systems (Victoria) Pty Ltd > >> Kew Victoria > >> www.bms.com.au > >> > >> On Fri, Apr 1, 2011 at 10:33 AM, Tom Rutter <[email protected]> > wrote: > >>> > >>> What web hosting company do you guys know of that offer lots of disk > >>> space? I haven't been able to find any more than 10GB. Cheers > > > > >
