Re: DTS and Cluster
From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 04/14/04
- Next message: Darren Green: "Re: Executing sp_start_job from Package"
- Previous message: Darren Green: "Re: bugs with IF, SKIPROW, or ISNULL?"
- In reply to: Tunji: "DTS and Cluster"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 14 Apr 2004 20:25:05 +0100
In message <ePdPD6kIEHA.2924@TK2MSFTNGP09.phx.gbl>, Tunji
<Tunj@hotmail.com> writes
>I assume its not required to have this package(s) run on both servers in an
>ACTIVE - ACTIVE environment.
>
>All opinions are welcome.
>
>Thanks
>
It is not required, but packages should be capable of being run on both
nodes, for when the cluster fails over. So any files a package needs
should be on cluster resource disks so that they move between nodes with
the package and sql server, assuming packages are stored in and executed
from a SQL Server instance.
-- Darren Green (SQL Server MVP) DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals http://www.sqlpass.org
- Next message: Darren Green: "Re: Executing sp_start_job from Package"
- Previous message: Darren Green: "Re: bugs with IF, SKIPROW, or ISNULL?"
- In reply to: Tunji: "DTS and Cluster"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
