Re: Clustering SSIS , this SSIS the question !!!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

http://weblogs.sqlteam.com/geoffh/archive/2007/10/04/To-Cluster-or-Not-to-Cluster-That-SSIS-the-Question.aspx


--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Carlos" <carlosarango@xxxxxxxxxxxxx> wrote in message news:43E84CDB-1418-4D95-B006-0552F79D5502@xxxxxxxxxxxxxxxx
I am pretty much confused as to what to do; According to MS
http://msdn.microsoft.com/en-us/library/ms345193.aspx, the disadvantages in
making SSIS cluster aware seem to be greater than the advantages; all I want
to do is to be able to run my DTS packages every time the cluster fails over
to the inactive node; what is the best and safest approach?

This is my current environment:

We are using SQL Server 2005, 64-bit, on a Windows 2003 clustered server
with Active/Passive 'A' and 'B' nodes. Databases are on a shared equallogic
iscsi SAN.

Any help would be greatly appreciated

.

Relevant Pages

  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Now, for the first problem, adding the 3rd node as a member of the cluster. ... You then installed a 2nd instance of SQL Server. ... DBC01 (Disks, SQL Server resources) ... Install RTM SS2K and designate the node membership. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: active/passive with multiple instances
    ... An Active/Passive cluster is always called that and never Passive/Active. ... There is only 1 SQL Server per instance:) Just so other don't get confused. ... It does matter about the hardware, to achieve true HA it needs to happen at ... a SQL Server DBA plain and simply doesn't care about it being ...
    (microsoft.public.sqlserver.clustering)
  • Re: High Availability
    ... The cluster uses heartbeat to detect whether a node is alive or not responding. ... You may want to research SQL Server Replication/ Log Shipping if you can have some latency. ... Typical Uses of Replication ... Introducing New Features in Microsoft SQL Server 2000 Transactional Replication ...
    (microsoft.public.sqlserver.clustering)
  • Re: Bad startup parameter on clustered instance
    ... you shouldn't directly edit the registry entries of a cluster-aware ... SQL Server resource to keep failing the startup. ... This is because the cluster service checkpoints its changes and basically ... Check the registry entries for the startup parameters on the node to make ...
    (microsoft.public.sqlserver.clustering)