Home Forums SQL Server 2005 Business Intelligence SSIS package for DR in database mirroring (job run when need to failover) RE: SSIS package for DR in database mirroring (job run when need to failover)

  • August 10, 2015 at 4:46 am

    #1818474

    Event i am looking for the same kind off solution to be implement. Please let me know,if anyone worked on this kind of solutions.

    We can refer : http://blogs.msdn.com/b/mattm/archive/2012/06/19/ssis-with-alwayson.aspx

    I have a thoughts like.

    1. Setup Database mirrorng for SSISDB

    2. Keep monitoring the state of the databases .

    3 Wite a logic in SQL Agent jobs which can run the pakages whereever primary it is .

    THanks