1 Reply Latest reply on Aug 29, 2012 5:11 PM by paul.enkelaar

    LDSD 7.4 on a SQL Mirror

    Rookie

      Hi,

      I am planning on upgrading our standalone SQL 2005 server to an Active/Passive Mirror setup for redundancy.

      Is there anythnig that I need to be aware of in terms of the itbm database? Will our users with the console installed just automatically connect to the mirror in the event of a failover? or will there need to be some manual re-configuring of the the 2console.exe.config" file on each workstaion?

       

      Any help or advice relating to running Service Desk 7.4 in a SQL mirror setup will be greatetly appreciated.

       

      Thanks

        • 1. Re: LDSD 7.4 on a SQL Mirror
          Expert

          Hi Adam

           

          We have set-up mirroring with automatic failover on SQL 2008 R2.  In general this has been working fine.  We did need to extend the default SQL time-out from 10 seconds to 60, as we found 10 seconds just was not long enough and so it kept failing over regularly.

           

          As far as failovers go, the users haven't been noticing anything when these occur - we use WebDesk with integrated authentication.  The only thing I have noticed (although I haven't been able to find the root cause) is that occasionally one or more of my TPS services may stop working and I think it may be in some way linked to the failovers, but can't be certain.

           

          Cheers

           

          Paul

          1 of 1 people found this helpful