![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
I assume its not required to have this package(s) run on both servers in an ACTIVE - ACTIVE environment. All opinions are welcome. Thanks |
#3
| |||
| |||
|
|
In message <ePdPD6kIEHA.2924 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, Tunji Tunj (AT) hotmail (DOT) 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 |
![]() |
| Thread Tools | |
| Display Modes | |
| |