SQL Server Performance

will SSIS on principal after a DB mirror failover to the mirror?

Discussion in 'ALL SQL SERVER QUESTIONS' started by Trev256b, Jan 15, 2012.

  1. Trev256b Member

    will SSIS on principal after a DB mirror failover to the mirror? or will you have to setup a copy of SSIS packages on the mirror as well?
  2. catullus Member

    could you be a bit more specific about your scenario?
  3. Shehap MVP, MCTS, MCITP SQL Server

    As per my simple understanding about your case, it is right you should install SSIS package on both DB principal and DB mirror servers to assure the continuity and reliability of SSIS package in any failover case happens

Share This Page