June 3, 2010 at 2:54 am
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
June 3, 2010 at 3:11 am
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
June 3, 2010 at 5:39 am
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.
June 3, 2010 at 5:44 am
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
June 3, 2010 at 5:52 am
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.
June 3, 2010 at 5:58 am
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
June 3, 2010 at 6:00 am
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
June 3, 2010 at 6:12 am
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 passiveWhy would configuring log shipping require converting the cluster to active/active though?
Exactly!
Thank you Gail 🙂
Adam Zacks-------------------------------------------Be Nice, Or Leave
June 3, 2010 at 6:17 am
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?
June 3, 2010 at 6:24 am
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
June 3, 2010 at 6:32 am
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. @=)
June 3, 2010 at 6:37 am
Ditto :blush:
Adam Zacks-------------------------------------------Be Nice, Or Leave
June 3, 2010 at 7:03 am
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
June 3, 2010 at 7:15 am
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.
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply