Error Kickmaleerie

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Tuesday, September 30, 2008

High Availability in SQL Server 2005

Posted on 11:11 AM by Unknown
Had a technical architecture document recently from an external supplier proposing a mirrored SQL Server 2005 setup with the Principal as a MSCS. Noticed in the Technet docs that:

"... you may consider using database mirroring as a method for creating a hot standby for a cluster instance database. If you do, be forewarned that because a cluster failover is longer than the timeout value on database mirroring, a High Availability mode mirroring session will react to a cluster failover as a failure of the principal server. It would then put the cluster node into a mirroring state."

Sooooo... this makes the use of a cluster Principal kind of redundant as if it fails over then SQL will move over to the Mirror server. For further info see the Mirroring FAQ.
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Posted in | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • Find SQL Servers on your Network
    Very useful script.
  • IIS6 Known Extensions feature
    Yesterday I ran across this issue when a user of our IIS6 hosting service reported that their Authorware applications were giving timeouts...
  • ARPs and NIC Teaming
    Background: A NIC Team is known by a single MAC address to clients in the network. This MAC address is only used as the source MAC address...
  • aacPlus delivers 48Kbps stereo
    As a listener to the very excellent Groove Salad on the online station SomaFM you have got to be impressed with the CD quality 48K aacPlus...
  • Dell iDRAC6 Virtual Media Detached error
    See the solution to this error here: http://www.it-book.co.uk/771/error-attaching-iso-in-idrac-%E2%80%93-virtual-media-is-detached
  • SQL 2008 Reporting Services and SCCM 2007 R2
    The above provides a link to the SCCM Team blog explaining why you must have Reporting Services configured against the default instance of S...
  • SSI stuff
    Useful info on SSI date and time formats and examples of their use. Not forgettng the Apache tutorial
  • Not such a bargain then
    I don't know why but many of my middle class friends and colleagues have a penchant for shopping in Lidl and seem to get genuine joy - u...
  • High Availability in SQL Server 2005
    Had a technical architecture document recently from an external supplier proposing a mirrored SQL Server 2005 setup with the Principal as a ...
  • Warhol and Web 2
    As Warhol noted in 1968 " in the future everyone will be famous for 15 minutes ". Andy had the vision but we just lacked the mecha...

Categories

  • logs
  • sawmill
  • w3c

Blog Archive

  • ►  2011 (9)
    • ►  October (1)
    • ►  August (2)
    • ►  July (1)
    • ►  June (2)
    • ►  May (2)
    • ►  April (1)
  • ►  2010 (8)
    • ►  December (1)
    • ►  November (1)
    • ►  August (1)
    • ►  June (1)
    • ►  April (1)
    • ►  March (1)
    • ►  January (2)
  • ►  2009 (5)
    • ►  July (1)
    • ►  May (2)
    • ►  April (1)
    • ►  January (1)
  • ▼  2008 (5)
    • ►  December (1)
    • ▼  September (1)
      • High Availability in SQL Server 2005
    • ►  August (1)
    • ►  July (1)
    • ►  February (1)
  • ►  2007 (11)
    • ►  November (1)
    • ►  October (1)
    • ►  August (1)
    • ►  May (2)
    • ►  April (2)
    • ►  March (2)
    • ►  February (1)
    • ►  January (1)
  • ►  2006 (15)
    • ►  December (1)
    • ►  November (3)
    • ►  October (1)
    • ►  September (2)
    • ►  August (1)
    • ►  July (4)
    • ►  June (1)
    • ►  March (2)
  • ►  2005 (25)
    • ►  October (1)
    • ►  September (2)
    • ►  August (9)
    • ►  July (1)
    • ►  May (1)
    • ►  April (2)
    • ►  March (1)
    • ►  February (3)
    • ►  January (5)
  • ►  2004 (16)
    • ►  December (6)
    • ►  November (10)
Powered by Blogger.

About Me

Unknown
View my complete profile