Service Operations Insight

  • Private Community
 View Only

  • 1.  SOI Database backup & restore Testing

    Posted Aug 01, 2018 06:08 AM

    HI Team,

     

    Can we restore production SAMStore Database in UAT fort testing the capability of Backup & restore functionality.If yes, is there any documentations for this ?

     

    We have scheduled production SOI manager upgrade in coming weeks. So would like to do a test of back up & restore of Prod SAMStore DB.

     

    Thanks and Regards
    Varun kumar



  • 2.  Re: SOI Database backup & restore Testing

    Broadcom Employee
    Posted Aug 01, 2018 07:51 AM

    Hello Varun, yes, you can move the SAMStore database from one server to another. SOI needs to be the same version and you need to run a few sql queries in order to make this run. Please watch this knowledge documents:

     

    https://comm.support.ca.com/kb/samstore-db-migration-procedure/kb000018523

     

    https://comm.support.ca.com/kb/registryloaderbat-fails-when-samstore-is-moved-from-one-server-to-another/kb000005789

     

    Please mark this thread as answered in case the articles helped to resolve your question.

     

    Kind regards,

    Britta Hoffner

    CA Support



  • 3.  Re: SOI Database backup & restore Testing

    Posted Aug 01, 2018 08:13 PM

    Hi Britta,

     

    Thanks for your reply on this.

     

    Will follow the document and let you know in case of any queries.

     

    Regards

    Varun kumar



  • 4.  Re: SOI Database backup & restore Testing
    Best Answer

    Posted Aug 02, 2018 02:23 AM

    Hi Varun,

     

    some additional thoughts:

    The document Britta referenced is meant to move the DB to a different SQL Server, but still being connected to the same SOI environment.

    You can use the same procedure to restore the DB into a different environment (from Production to UAT), but you will not be able to "test" anything in that environment, because all identifiers refer to the original environment.

    In UAT all connectors will have different identifiers, and thus you will get all the CIs from these connectors in addition to the ones you restore from Production.

    If you only want to test that moving a DB works, e.g. see if all info is still available following the move, the procedure is fine.  But you cannot continue using the DB in the UAT environment, because the info in the DB will be a mix of both environments with all info coming from Production pointing to non-existing CIs.

    CA Support is often using the procedure to get a customer's DB into a local environment, but only to analyze tables or find inconsistencies, e.g. a static snapshot.

     

    MichaelBoehm



  • 5.  Re: SOI Database backup & restore Testing

    Broadcom Employee
    Posted Aug 06, 2018 09:52 AM

    Hello Varun, do you have additional questions for this thread ? If not please mark it as answered.

     

    Thanks and kind regards,

    Britta Hoffner

    CA Support