Post reply

Hosted Witness

  • January 18, 2011 at 9:02 pm

    #233062

    Does it make sense to subscribe to a hosted witness service, instead of adding a Witness Server to your current infrastructure?

  • January 25, 2011 at 8:32 pm

    #1278276

    Not worth the hassel. You can use SQL Server Express (free!) as a witness for database mirroring. Why would I pay for this functionality when it is easily setup in-house?

  • January 25, 2011 at 10:47 pm

    #1278291

    I agree, and was thinking the same thing. The only reason I posted was the thought of having to purchase a seperate server just for witness.

    True, you could just throw up a VM and buy another windows license (which is probably the cheapest way to do it), but why add overhead to your current infrastructure in you don't have to?

    Thanks for your input.

  • January 26, 2011 at 1:03 am

    #1278320

    tjryberg (1/25/2011)

    The only reason I posted was the thought of having to purchase a seperate server just for witness.

    You don't need a dedicated server. It can run on a desktop-type PC if you like. It can share with something else (though should not be on the same server as principal or mirror)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 26, 2011 at 8:57 pm

    #1278909

    True that. I did have one vote for yes, and another for "depends"... I suppose it all depends on your environment. Doesn't seem to be a popular idea, though 🙂

Viewing 5 posts - 1 through 5 (of 5 total)

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