Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  Using a backup of a database

    Posted 5 days ago

    We accidentally deleted a bunch of folders and need to restore them. We have a copy of last night's database. Is it possible in Cognos configuration to point to the backup content store? Will Cognos just magically work when we start it pointed at the different content store? 

    Is there another way to if this wont work?

    We are using Oracle for our content store and have Cognos 12.1.0



    ------------------------------
    Will Phillips
    ------------------------------


  • 2.  RE: Using a backup of a database

    Posted 5 days ago

    Hello Will,

    In my environment, we're using SQL Server for the Content Store. I've done this before by stopping the Cognos services, restoring the Content Store database from the backup, and then starting Cognos again. Once Cognos came back up, all of the folders and content were restored to the state they were in when the backup was taken.

    The main thing to keep in mind is that you'll lose any Content Store changes made after the backup, such as new reports, updated reports, schedules, security changes, or other content modifications that occurred between the backup time and now.

    If you only need to recover a few deleted folders, a safer approach would be to restore the backup to a separate database, temporarily point a Cognos instance to that restored Content Store, export the missing folders, and then import them back into your live environment. That way, you can recover the deleted content without affecting any changes that users have made since the backup was taken.

    Thank you,

    Abbas



    ------------------------------
    [Abbas] [Alnamar]
    [Data Management and Analytics System Administrator]
    [Emporia State University]
    [Kansas, USA]
    ------------------------------



  • 3.  RE: Using a backup of a database

    Posted 5 days ago

    That is my plan. I will point my TEST Cognos instance to the backup Content Store and create a deployment file for the missing folders. I hope it works :-)
    I was just wondering about any cert issues or crypto keys not working when I re-point. 



    ------------------------------
    Will Phillips
    ------------------------------



  • 4.  RE: Using a backup of a database

    Posted 4 days ago

    Hi Will,

    I have two tips to add, as experience from my own practice:

    1. Deployments as backup - It is practical to frequently backup the folders (at any level in the folder structure) that are most important by defining one or more scheduled deployment exports. These can be helpful to restore missing content by performing a direct or indirect (into a temporary location) import into the current content store.
    2. Copy content data for testing - It could be wise to extensively test an upcoming Cognos release upgrade in a separate Cognos test instance by creating a full copy of the operational content store database or schema in that database (in Oracle Enterprise Manager: Schema Export/Import) and then pointing the test instance to that copied schema for as long as the test period lasts. This reduces stress from the live upgrade and provides as much time as needed to perform tests of developed objects and new and changed product features.


    ------------------------------
    Marc van Waardenburg
    ------------------------------