Copy SSIDB from one server to another

• PJ_SQL

  SSCertifiable

  Points: 6703

  More actions

  April 21, 2015 at 3:56 pm

  #303205

  Hi,

  For copying the SSISDB from one server A to another B I used the following steps:

  Took backup of SSISDB on server A.

  On Server B, created a new SSISDB catalog.

  Restored the newly created SSIDB on B from backup of the DB from server A.

  Please let me know if this is the correct process for SSISDB or not.

  Thanks.

• joshdbguy

  SSCertifiable

  Points: 7707

  More actions

  April 21, 2015 at 5:00 pm

  #1792591

  Check out this official page from Microsoft,

  https://msdn.microsoft.com/en-us/library/hh213291.aspx