logshiping on cluster server.

  • Hi all,

    Is it possible to set the logshiping on cluster server.

    My primary Database Environment cluster from this server i like to set logshipping on secondary server (DR).

    both the server are in same domain,

    Regards,
    Shivrudra W

  • Yes this is easily done.

    Personally i would g o with database mirrioring (without witness), its easier to setup and administer.

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • Depends on what kind of cluster you have set up. If it's Active / Active, then yes, you shouldn't have a problem. If it's Active / Passive, you have a problem and will need to break the cluster and rebuild as an Active / Active.

    Why use a cluster for Log Shipping? If you're trying to build in disaster recovery with LS, it seems silly (no offense) to do it on a setup that's already configured for DR.

    If you're doing it for a read-only report server, though, then that's a different matter completely.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • why would you need to set to a/a? we have a/p and mostly use mirrors to our scf site but have used ls aswell.

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • Active / Active has a SQL instance on both nodes. Active / Passive has the instance only on one node. If you have instances on both nodes, you're running A/A whether you realize it or not.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Thanks for the tutorial. I know what we have as i built them. They are two seperate a/p clusters and we mirror and log-ship to our scf dr server.

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • Active/active has minimum 2 instances installed and has at least one instance running on both nodes. Active passive has instance only running on one node, installed but not running on the passive

    Why would configuring log shipping require converting the cluster to active/active though?

    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
  • GilaMonster (6/3/2010)


    Active/active has minimum 2 instances installed and has at least one instance running on both nodes. Active passive has instance only running on one node, installed but not running on the passive

    Why would configuring log shipping require converting the cluster to active/active though?

    Exactly!

    Thank you Gail 🙂

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • You can log ship to a server that has no instance?

    I thought log shipped databases were in a state of Recovery? I thought they needed an instance to reside on. And the way the original post read, it sounds like the poster wanted to send from 1 node to the second node, not put the log shipped DB on the Active node.

    Am I missing something?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Brandie Tarvin (6/3/2010)


    You can log ship to a server that has no instance?

    I thought log shipped databases were in a state of Recovery? I thought they needed an instance to reside on. And the way the original post read, it sounds like the poster wanted to send from 1 node to the second node, not put the log shipped DB on the Active node.

    Am I missing something?

    No Brandie, your not. Just re-read the origenal post and i missinterperated. Because the term 'passive' was not used, i ***-u-and-me'd that the poster meant a seperate dr server that is offsite (like we have).

    In this case I was wrong and you are right. The poster could not mirror or log ship to the secondary node unless it was a/a, if the secondary node is a passive for the a/p, there would be no instance to host the mirror/revovery database on.

    Sorry Brandie, you were right.

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • Well the OP isn't clear if the second server is on the cluster or not. I'm just assuming that's what (s)he meant.

    But it wouldn't be the first time this week I said something totally stupid because I wasn't thinking. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • Ditto :blush:

    Adam Zacks-------------------------------------------Be Nice, Or Leave

  • Brandie Tarvin (6/3/2010)


    nd the way the original post read, it sounds like the poster wanted to send from 1 node to the second node, not put the log shipped DB on the Active node.

    Not the way I read it. I read it that he wants to log ship from the cluster to a secondary server (DR Server). Nothing to indicate that the secondary server is the failover (passive) node.

    Log shipping to a failover node of the cluster is frankly stupid. It's gaining nothing (still single point of failure) and unnecessarily loading failover cluster node (with both log shipping primary and secondary) in the case of a failure of the primary node

    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
  • GilaMonster (6/3/2010)


    Log shipping to a failover node of the cluster is frankly stupid.

    Yeah, well, I tried to be nicer about that point in my first point on this thread.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 14 posts - 1 through 13 (of 13 total)

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