Make sure your Host backs up SQL!!!

  • Check their terms, but in searching for colocation, I've found they are all about the same. Especially if you are the little guy, you will be low in the priority list.

    If this is a personal thing, then you might be better off trying to get broadband and hosting your own site.

    Steve Jones

    steve@dkranch.net

  • But be carefull there in that many have rules against running a server and will boot you, but this seems to be only in extreme cases.

  • Antares,

    I spoke with a tech support guy. They actually back up the sql boxes nightly. One thing concerned me - they back up all their sql machines to a backup machine. He didn't think the data ever went to tape. When I asked what happened if a hacker wipes out the sql box AND the backup box, he didn't have a solid answer.

    Hmmmmmmmmm

    Steve,

    Got broadband but no static IP (cable). I'd rather spend my time doing development, than administration and maintenance anyway.

    Thanks,

    John

  • But do they give you a guarantee in writing about your data. Even if they backup to tape, tapes can fail. Do they guarantee they verify and insure things are really working and do they back it up in writing.

  • Hmmmm Nope. Don't think so.

  • Then they really offer what you had before. And thus you get the same possible results, your data being lost is not their problem. And I bet the backup machine is a copy of the original machine as a whole, so if you get any data corruption it could be copied to the backup box and corrupting that data as well.

  • Bottom line, get it in writing. It's not a question of if, it is a question of when. And when it does happen, without anything in writing, you have no leverage, even if they did take a backup.

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • I've got DSL and for an extra $35, I got static IPs. It is nice, but you have to understand some networking, plus you want to secure your boxes.

    I understand. I'd just see if they can email you or allow ftp once in awhile to grab the db (or the backup).

    Steve Jones

    steve@dkranch.net

  • Here's a question. When offering a service such as SQL Server hosting, at what point does the lack of preparedness for disaster recovery become negligent? I believe a court would agree that regardless of what the Terms of Service or contracts say, they have to take reasonable and customary measures to protect the data. Not having any form of backup IMHO is negligent on their part.

    What do you think? What is reasonable to expect of a web host?

  • But unfortunately thanks to Gates and many other folks in the industry the government is on their side. As long as they have the right legal statements and you agree electronicly then you acctually are assuming the responsibility by not having a backup yourself.

  • We can look at the banking industry for a precedent. If you choose to put your money in a non-FDIC insured bank, and they are robbed, oh well. Even with the FDIC, only the first $100,000 (US) is ensured (okay, okay, we'd all like more than $100,000 in the bank).

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • Brian,

    Give me my 100K and I walk away with a smile on my face!

Viewing 12 posts - 16 through 27 (of 27 total)

You must be logged in to reply to this topic. Login to reply