Forum Discussion

woelki's avatar
woelki
Level 4
7 years ago

Upgrade SQL Server for EV and DA

Hi there, we are just planning to upgrade our EV and DA environment in two steps. Currently we have EV and DA in version 11 with an standalone SQL Server 2008 R2 We want to upgrade to EV12 and ...
  • Massimo_Vagli's avatar
    Massimo_Vagli
    7 years ago

    Hello Chris, 

    In my test environment I have upgraded few times some old SQL servers (such as 2008 or 2012) to a newer version (such as 2014 or 2016) and I never had any issues.

    As long as the upgrade path is supported my Microsoft, the new SQL Server version is supported by the EV version in use and the upgrade is done with Enterprise Vault and DA services stopped I don't see any issues.

    I would recommend the following: 

    1. before stopping the Enterprise Vault services put the vault stores and indexing in backup mode

    2. before do the actual upgrade do a SQL databases backup (so in case something goes wrong you can go back, about it please take a note of the current service pack for SQL installed)

    3. after the SQL upgrade start the EV services (leave them in backup mode) and check if Enterprise Vault can properly connect to the new SQL server version, check from the admin console some of the settings, test some retrieves, do some searches etc...)

    4. remove the backup mode for the vault store and indexes

    The aforementioned procedure is just from common sense and it is not supposed to be taken like an official procedure or covered by any support.

    Massimo Vagli

woelki's avatar
woelki
Level 4

Hi Massimo,

thanks for the comprehensive guide. Sounds like a plan.

GertjanA
Yes, I have considered this, but I would like to do this as a safety job for myself. I know that EV11 would support this, but for sure I would like to have the databases without mirroring on the cluster.
My SQL admin recommended the upgrade of the standalone server for one simple reason. If something fails at the move to the cluster, we have a rollback possibility.

The EV part is answered so far.
Is there anything I have to look out for regarding DA when I upgrade SQL server?

Kind regards,

Chris

 

GertjanA's avatar
GertjanA
Moderator
7 years ago

Hi chris,

No specifics for DA needed. Just upgrade SQL, start services (as mentioned by Massim) and continue. You'll see errors really soon after starting services if there is an issue with SQL.

Point to note on your remark on mirroring databases on your new cluster. Be advised that for an upgrade of EV, you will have to break the mirror on the EV databases. That is listed in upgrade documentation, but easily overlooked.

  • woelki's avatar
    woelki
    Level 4
    7 years ago

    Hi GertjanA,

    thanks for the reminder. Therefore I wanted to move the databases to the cluster in the last step.

    1. Upgrade standalone SQL Server to 2014

    2. Upgrade to EV12

    3. Move databases to SQL cluster instance and create mirror.

    Kind regards,

    Christian

    • woelki's avatar
      woelki
      Level 4
      7 years ago

      Dear all,

      just to update you, SQL upgrade to version 2014 succeeded.

      I've got one follow up question.
      When we finished the upgrade my SQL admin asked me if we should change the database compatibility level.
      In order to stay on the save side we did not change it.

      So currently it is level 100 (2008 R2) and we could raise it up to level 120 (2014).
      Is it recommended to execute the change?

      Kind regards,
      Chris

      • VirgilDobos's avatar
        VirgilDobos
        Moderator
        7 years ago

        Hi Chris,

        Yes absolutely, you can do that. It would do no harm to EV.