Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Integration Hub H2L
  • All Products

Table of Contents

Search

  1. Abstract
  2. Supported Versions
  3. How to backup and restore Data Integration Hub repository and Power Center Repository Service

How to backup and restore Data Integration Hub repository and Power Center Repository Service

How to backup and restore Data Integration Hub repository and Power Center Repository Service

Back Next

Backup and Restore Data Integration Hub for SQL Server Database

Backup and Restore Data Integration Hub for SQL Server Database

Perform the following steps to backup and restore Data Integration Hub metadata and publication repository databases:
  1. Shut down the Data Integration Hub services.
  2. Perform the following steps after connecting to the appropriate instance of the Microsoft SQL Server Database Engine:
    1. Expand the server tree in
      Object Explorer
      .
    2. Expand Databases, right-click the database name and select
      Tasks
      Back Up
      .
  3. In the
    Source
     section of the
    General
     page, select the
    Copy-only backup
     option. Select
    Disk
     from the
    Back up to
     menu in the
    Destination
     section.
  4. Click
    Add
    .
    The
    Select Backup Destination
     dialog box appears.
  5. Enter the file name and a valid directory. Use
    .bak
     file extension to simplify the classification of this file.
  6. Click
    OK
    .
    The backup process begins.
  7. After the backup is complete click
    OK
     to close the
    SQL Server Management Studio
     dialog box.
  8. Manually backup the docstore folder for filestore topics in the Data Integration Hub repository.
    1. Get the docstore location from the system property
      dx.system.document.store.folder
       from the Data Integration Hub repository that you need to backup.
    2. Keep a backup of this folder to copy it to the new Data Integration Hub instance location.
  9. Perform the following steps to restore the backup of the metadata and publication repository databases to a new database:
    1. In
      Object Explorer
      , connect to an SQL server database engine instance and expand that instance.
    2. Right-click
      Databases
       and select
      Restore Database
      .
    3. In the
      Source
       section of the
      General
       page, enter the source directory of the backup sets to restore.
      The following options are available:
      • Database
        . The list contains the backed-up databases according to the
        msdb
         backup history.
        If the backup is taken from a different server, the destination server will not include the backup history information for the specified database. In such a situation, select
        Device
         to manually enter the file or device to restore.
      • Device
        . Click
        Browse
         and the
        Select backup devices
         dialog box appears.
        • Select the media type as
          File
           from the
          Backup media type
           menu. Click
          Add
          .
        • Locate the back up file and click
          OK
          .
        • In the
          Destination
           section, the
          Database
           box automatically populates the database name to restore. Change the name of the database to the new Publication and Metadata database name.
    4. In the
      Options
       page, select the following options:
      • In the
        Restore options
         panel, select
        Overwrite the existing database (WITH REPLACE)
        .
      • In the
        Server Connections
         section, select the
        Close existing connections to destination database
         check-box.
    5. Click
      OK
      .
      The restore process begins.
    6. After the restore is complete click
      OK
       to close the
      SQL Server Management Studio
       dialog box.
0 COMMENTS
We’d like to hear from you!