How to restore Assets/Insight data


Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

    

Summary

When it comes to complete Assets dataset restoration, there is no functionality available to completely back up / restore Assets data only. There is a feature request open for this functionality. 


When accidentally removing some Assets / Insight data and there is a requirement to restore it, this page will show four approaches to take into consideration. 

Environment

  • Supported Jira Version
  • Supported Assets or Insight Asset Management app


Solution

Alternative ways to get the Assets - Insight data back, especially when the original Jira database backup is available (and another Jira instance that can be used to restore that data to):

Object Schema Export 

Using Object Schema Export, the valid dataset can be exported from another Jira instance and then imported it into the affected Assets / Insight instance.

As noted in the documentation article, exporting an object schema currently does not include the import configuration nor connection to Jira Issues/Tickets. i.e your JSON import, CSV, LDAP or references to Objects in another Schema will not be imported.

Assets object schema import type 

Assets object schema import type can help with importing all object-schema-related data from another Jira instance (object types, attributes, objects).

However, Automation rules, Roles, and any import configurations will not be imported from the source instance.

    • If possible, the recommendation is to use this solution to restore the data, as it will not affect the Jira data.

Jira XML backup / restore functionality

The most complete dataset would be, of course, a Jira XML backup / restore functionality, however, this will restore all other Jira data as well, and it will require downtime.

Restore only Assets database tables and data

Lastly, there is an option to restore only Assets / Insight database tables and data, from the SQL database that contains original data.

Bare in mind, this will only work properly if all the data comes from the same database (hence, if all table row IDs are the same on the source and target database) since Assets / Insight objects may have references to Jira issues.

    • The Assets tables begin with pattern AO_8542F1_IFJ*, restoring only the content of these tables is required.
    • The Assets database page contains relationships between Assets tables, and it will show how the tables are interconnected.

      Bear in mind, Support cannot provide official support for this method as it goes beyond our Support Scope. Make sure to back up the SQL database before doing any restoration onto it.



Last modified on Jan 27, 2025

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.