Network Management

 View Only
last person joined: yesterday 

Keep an informative eye on your network with HPE Aruba Networking network management solutions
Back to discussions
Expand all | Collapse all

IMC, migrating from external SQL srv to new setup with interal

This thread has been viewed 55 times

  • 1.  IMC, migrating from external SQL srv to new setup with interal

    MVP
    Posted Jan 05, 2023 08:09 AM

    Customer has a rather small setup and would like to downsize when upgrading IMC/servers.

    Current setup is using IMC 7.2 on an older Windows server with an SQL srv 2008 on a different machine.
    They would prefer getting rid of the extra SQL server entirely and using IMC with embedded dbase.

    Can someone confirm this would basically just entail the following?
    - backup old sql srv 2008 dbase
    - setup IMC (same version as old IMC) on new server using embedded dbase
    - transfer licenses
    - restore sql srv databasbackup into sql express embedded dbase
    - upgrade new IMC to 7.3

    Or is migrating from full sql srv to embedded going to give me headaches and other issues?



  • 2.  RE: IMC, migrating from external SQL srv to new setup with interal

    EMPLOYEE
    Posted Jan 06, 2023 02:30 AM
    Hello Koen,

    Here you can find the iMC Windows Migration guide, which can be helpfull for you:

    https://asp.arubanetworks.com/downloads;search=WINDOWS%20MIGRATION%20GUIDE;products=HPE%20Intelligent%20Management%20Center%20%28IMC%29

     Also some points to consider:
      - Old 7.2 iMC version is installed with old 2008 embedded database.
     - first iMC version that supports SQL 2008, 2012, 2016 and above is 7.3 E0605.
    This version is insstalled with embedded 2016 SQL Server.
     - considering above it would be better that  you first upgrade your old server to 7.3 E0605  and than make new installation with E0605(Sql 2016) and migrate the data.
    - please be aware that there might be issues during upgrade of old server . Please check release notes of the respective version and take a backup from iDMA before every upgrade. In E0605 there is a known issue  with cipher suits , which causes db connection errors. An  iMC tool has been  developed to remove them before upgrading to E0605.Please check the release notes for instructions.


    I hope , this will help you!

    Kind regards,



    ------------------------------
    Marina
    HPE
    Sofia
    ------------------------------

    Original Message


  • 3.  RE: IMC, migrating from external SQL srv to new setup with interal

    MVP
    Posted Jan 26, 2023 08:23 AM
    Hi Marina.

    Their old 7.2 E0403version is installed with an external SQL 2008 server dbase. The new server will be using the embedded database.

    Since 7.2 has support for external sql 2008 (as in use at customer) and for embedded 2008 (new setup), I should be able to use that version to backup/import right? This way I can leave the original setup (7.2 E0403 with external sql 2008) running as is and easily go back to that install if the import into the new setup (7.2 E0403 with embedded sql 2008)  or any of the upgrade path fails for any reason.

    To me this seems like the safer option.  Do you concur?  Or am I missing the reason why this would be the worse way to do this migration?
    Original Message


  • 4.  RE: IMC, migrating from external SQL srv to new setup with interal

    EMPLOYEE
    Posted Jan 26, 2023 08:36 AM
    Hello Koen,

    I agree with you on the point that  iMC 7.2 does support installation with SQL Server 2008 R2 embeded or remote. And I assume  you will not have any problems, when migrating the data to the new server with iMC 7.2 with embedded 2008 R2 sql.

    But you will have issues when upgrading to version 7.3 E0705 ( I assume you plan to go to the newest version , which is currently 7.3 E0708)
    The problem is, that since 7.3 E0705  we  no longer support old 2008 R2 SQL.
     So you will need to do a second migration on version 7.3 E0605 , which is the version , which still supports old 2008 R2, but also newer 2016 version of SQL.

    Kind regards,

    ------------------------------
    Marina
    HPE
    Sofia
    ------------------------------

    Original Message


  • 5.  RE: IMC, migrating from external SQL srv to new setup with interal

    MVP
    Posted Feb 01, 2023 05:58 AM

    Wow.. this upgrade is promising to be even more 'fun' than expected :)

    - start with original server #1 running IMC 7.2 E0403P04
    - backup old sql srv 2008 dbase
    - setup IMC (same version as old IMC) on new server #2 using embedded dbase
    - transfer licenses
    - restore sql srv databasbackup into sql express embedded dbase
    - upgrade srv#2 IMC to 7.3 E0604
    - remove affected cipher suits
    - upgrade new IMC to 7.3 E0605
    - backup 2008r2 dbase
    - setup (final) server #3 IMC (7.3 E0605)
    - transfer licenses
    - import 2008r2 backup into 2016 dbase
    - upgrade srv#3 IMC 7.3 E0708


    Thank you for your input. Much appreciated!​


    Original Message


  • 6.  RE: IMC, migrating from external SQL srv to new setup with interal

    EMPLOYEE
    Posted Feb 01, 2023 06:17 AM
    Hi Koen,

    Keep in mind that you would not need IMC to be licensed for the backup/restore/upgrade operations to work, as those are done via the DMA and not the web GUI (and even that would allow 60 days trial login, until you restore the DB). So you could save yourself one set of license transfer by simply transferring the license to the final installation SN once the process is complete.

    ------------------------------
    Justin Guse
    ------------------------------

    Original Message


  • 7.  RE: IMC, migrating from external SQL srv to new setup with interal

    EMPLOYEE
    Posted Feb 01, 2023 07:46 AM
    Hello Koen,

    Also be aware that you can not upgrade server 3 from E0605 to E0708 directly , you need to go through E0705 version.

    Regards,

    ------------------------------
    Marina
    HPE
    Sofia
    ------------------------------

    Original Message


  • 8.  RE: IMC, migrating from external SQL srv to new setup with interal

    MVP
    Posted Feb 13, 2023 08:23 AM

    Trying to take a backup..

    Ran installslave.bat on the remote dbase server. copied over the dbman directory from the main server, ran start_dbman.bat.

    After doing all the above, I can't seem to run a backup. debug log on both servers gives following:

    2023-02-13 16:40:03 [DEBUG] [My_Accept_Handler::handle_input] Connection established 127.0.0.1
    2023-02-13 16:40:03 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10002
    2023-02-13 16:40:03 [DEBUG] [CDataConnStreamQueueT::deal_msg] Succeed to create ManualBackupDBase thread .
    2023-02-13 16:40:03 [INFO] [Client::connect_to_server] Starting connect to <ip dbase srv>: 2810
    2023-02-13 16:40:03 [INFO] [Client::connect_to_server] Established connection to <ip dbase srv>: 2810
    2023-02-13 16:40:03 [ERROR] [ManualBackupDase] All server echo ok
    2023-02-13 16:40:03 [INFO] [CDbBackup::BackupAllDataBase] Begin to manual backup all databases. Backup directory: C:\Users\<user>\Documents\backup
    2023-02-13 16:40:03 [INFO] [CDbBackup::BackupAllDataBase] ServerCount = 1
    2023-02-13 16:40:03 [INFO] [CDbBackup::BackupAllDataBase] Path: <dns db-srv>@aclm_db_imc_aclm_db_20230213_164003_full.db
    2023-02-13 16:40:03 [INFO] [Client::connect_to_server] Starting connect to <ip dbase srv>: 2810
    2023-02-13 16:40:03 [INFO] [Client::connect_to_server] Established connection to <ip dbase srv>: 2810
    2023-02-13 16:40:03 [DEBUG] [My_Accept_Handler::handle_input] Connection established <ip dbase srv>
    2023-02-13 16:40:03 [DEBUG] [CDataConnStreamQueueT::deal_msg] Receive command code: 10019
    2023-02-13 16:40:03 [INFO] [sendTrapAlert] Send trap success 

    2023-02-13 16:40:03 [ERROR] [response_err_code] errCode = 0
    2023-02-13 16:40:03 [ERROR] [Client::send_backupdbase_msg] Remote return error: Can't find the zip file when backup
    2023-02-13 16:40:03 [WARNING] [CDbBackup::BackupAllDataBase] Backup database: aclm_db failed
    2023-02-13 16:40:03 [ERROR] [ManualBackupDase] manual backing fail
    2023-02-13 16:40:03 [ERROR] [response_err_code] errCode = -1


    Any ideas what might be causing this? Ir will I need support before I can backup this db? 



  • 9.  RE: IMC, migrating from external SQL srv to new setup with interal

    EMPLOYEE
    Posted Feb 02, 2023 08:01 AM
    Hi Koen,
    one consideration about moving from an external database to the embedded database is the size limitation to each db in the embedded product.

    Before you start, read the restrictions for embedded database, in particular the number of nodes and each db's current size in DMA's environment tab:

    https://asp.arubanetworks.com/downloads/documents/RmlsZTpiOTIxODg2OC05NDdkLTExZTktOGIyYS1kZmQxNDMxNzQwNTA%3D]

    If any database exceeds 10G you will need to remove data or the restore will fail. For example, remove some monitors if the perf_db exceeds 10G.


    Original Message