Just in case you were considering this
http://www.interland.com/
provides internet accessible MS-SQL dbs packaged with many of their web-
hosting plans.
I have two such dbs.
Interland backs up theses databases daily but does not provide access to
theses backups directly.
Recently I used DTS to transfer one of my databases to my personal
workstation. In the transfer, a table was mangled, and eventually, I deleted
all the records from it, to clear the gibberish that was appearing, both in
the original copy and the downloaded copy.
On February 3 I submitted a support ticket via the internet asking that my db
be restored from January 31.
I got no satisfactory response to my ticket until I made a series of
telephone calls, the last one a half hour ago. The SQL team called me to tell
me the Restore would cost $350.00 USD. (What am I missing here? I've done
restores on dedicated servers in about 20 seconds.)
Well, after 1/2,147,483,647 seconds I decided the Restore wasn't worth quite
that much.
If you are considering Interland, you might want to think about their SQL
interaction.
I can say that in three years I have only to contact them about one other
issue. That is when I found the login information for another company's db
stored on my web-server. (I checked it and, YES, I had total dbo access to
the other company's db.) I notified Interland about this, but I was unable to
convince them that this might indicate a problem with THEIR security. One
representative told me that what was on my server was MY responsibility.
Well ... do you think I should look for another web-hosting, MS-SQL hosting
company ... and if so, do you have any recommendations? I've been writing
INFO or whomever at some sites with questions about MS-SQL hosting; so far
just one, DiscountASP.NET, has resonded in a way that makes me think they
might actually know what a database is. And they responded in about ten
minutes. Wow!
(NO, I do not work for DiscountASP.NET, I know very little about them and I
am not advertising them).
I used to be a fan of Interlands ... and I can attest that I feel
sufficiently sheepish right now ... no need to point out the things I did
wrong.
Now to go populate that table manually. It will take about 2 hours ... hmmmm
350/2=175 ... not too bad a rate per hour.
--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)