DR scenario question

• Panks-913490

  SSCrazy

  Points: 2131

  More actions

  July 7, 2010 at 3:20 am

  #141020

  Hi,

  I have a scenario I need to mirror all my SSIS pacakges and sql agent jobs from my production server to the failover server. There are like 50 packages or so.

  One option is manual deployment each time.

  Is there anyway to automate this something on the lines of replication?

  Can anyone suggest how can I do so.

  Thanks

• magasvs

  SSCertifiable

  Points: 7660

  More actions

  July 13, 2010 at 7:49 pm

  #1192482

  You can schedule jobs with dtutil command to copy SSIS packages. I have never used the solution provided in article below, but it may help you:

  http://www.databasejournal.com/features/mssql/article.php/3734096/Using-dtutil-to-copy-SSIS-packages-stored-in-SQL-Server.htm