How do I back up the Analysis Center databases? (NETIQKB48684)

  • Document ID:7748684
  • Creation Date:02-Feb-2007
  • Modified Date:25-May-2011
    • Micro Focus Products:
      Analysis Center

Environment

NetIQ Analysis Center 2.x
Microsoft SQL Server

Situation

How do I back up the Analysis Center databases?

Resolution

To back up the Analysis Center databases so they are synchronized:

  1. Using SQL Server Management Studio, connect to the SQL Server and Instance, if applicable, where the AC Data Marts are located and disable (not stop) the ETL jobs for the Data Source.
  2. Using SQL Server Management Studio, connect to the SQL Server and Instance, if applicable, where the existing AC Data Warehouse resides and disable (not stop) the Analysis Center (OLAP Processing) job.
  3. If the ETL job for each data source is running, wait until the job completes.
  4. Launch the AC Console to disable each data source.
  5. Back up the Data Mart databases.
  6. Wait until the Analysis Center (OLAP Processing) job completes on the old data warehouse machine and is disabled.
  7. Close all AC consoles and perform a SQL Server backup of the old AC_Warehouse and AC_Configuration databases.
  8. Start the AC Console and re-enable the data sources that were disabled.
  9. After the ETL jobs have been recreated, start the Analysis Center (OLAP Processing) job on the AC Data Warehouse machine.

Additional Information

Formerly known as NETIQKB48684