Results 1 to 4 of 4

Thread: Redundancy

  1. #1
    Join Date
    Nov 2003
    Location
    Akld, NZ
    Posts
    38

    Unanswered: Redundancy

    Hi All,

    After some feedback from some of you who might have done something similar:

    We are going to be having 3 SQL servers (running SQL Std licence).
    2 Are live
    1 is a hot swap in the event that we have a total loss of either of the SQL boxes.
    Basically what I am wanting to do, is have the hot swap being updated periodically so that the databases are being replicated on this box, so that if the live one fell over, we could very quickly get the hot swap into take over.

    Can anyone offer any perspectives on the best method of attack for this?

    Thanks in advance for your thoughts.

    Cheers
    Sideways see's more scenery

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Try to implement your own log shipping by referring to this article http://www.sql-server-performance.co...g_shipping.asp and this http://support.microsoft.com/default...b;en-us;314515 KBA for FAQs about LS.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Nov 2003
    Location
    Akld, NZ
    Posts
    38

    Thumbs up

    Brilliant - thanks this is exactly what I was after.

    Thanks!
    Sideways see's more scenery

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    This is only a thought, but you could also do transactional replication to the third box. If one of the two other servers dies, all you need to do is drop all of the replication and rename the third box to take the place of the downed server.

    This buys two advantages from my perspective... First, it gives you a "live" set of data that you can query, etc. to take load off of your production database(s). As a nice side benefit, it gives you literally "up to the minute" data, there is no loss due to log shipping delays if you ever need to use it!

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •