I'm looking for an ASP.NET and SQL Server host for a site I'm developing. Here's the important caveat though: I have a backup of a SQL database (.bak file) and need to be able to restore this database on the host.
Can someone refer me to a host where I have enough control over SQL Server that I can restore a database .bak file?
I believe CrystalTech lets you use SQL Management Studio to manage you database. I've used it in the past and they have great customer support.
Softsys Hosting also offers Management Studio access.
You can probably do restore from backup if they allow Management Studio access, right? I haven't tried myself, but I assume you can.
You can restore backups at webhost4life. Can you explain why you need to restore a backup? A lot of the time you can just script your schema+data and run the script on the server.
http://www.discountasp.net/ should do the trick.
SQL Hosting specifics: http://www.discountasp.net/sp_sqlhosting.aspx
SQL Management Studio won't allow you to restore database from a local file. The backup file should be accessible by SQL Server - this normally means that backup file should reside on the SQL Server itself.
Softsys Hosting allows you to upload your backup file though (using DotNetPanel). You can even zip it, to conserve traffic.
I would second webhost4life, i been with them less then a year, but it's been great. It is also allows you to take database backups and restore, manage it trough sql management studio, good customer service, and very fast servers.
I am running with them my personal web forum (around 1k users and growing) and so far they been very good experience for me.
Heard many good things about CrystalTech as well
Gearhost.com allows you SQL Server Management Studio access. You need to get the dedicated server to be able to restore and backup your server yourself; otherwise you'll need to submit a ticket for them to do it. Their average response time from ticket inception to completion is about one hour (from experience).