# Failover server

**URL:** <https://www.finalbuilder.com/forums/t/failover-server/6414>\
**Category:** Discussion\
**Tags:** continua-ci\
**Created:** [February 6, 2019, 10:10pm UTC](https://www.finalbuilder.com/forums/t/failover-server/6414 "2019-02-06T22:10:30Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![jeremys](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/jeremys/32/130_2.png) [@jeremys](https://www.finalbuilder.com/forums/u/jeremys)\
**Post date:** [February 6, 2019, 10:10pm UTC](https://www.finalbuilder.com/forums/t/failover-server/6414/1 "2019-02-06T22:10:31Z")

</div>

We’ve had to unexpectedly take our system that runs the Continua Server offline due to some (possible) hardware issues, which has made it so we can’t do any of our release builds.

Does the Continua Server have the concept of a backup server or a failover server? If not, what’s the best way to set up a backup server that we could get online and get everything back and running with minimal downtime?

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![Sparky](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/sparky/32/10_2.png) [@Sparky](https://www.finalbuilder.com/forums/u/Sparky)\
**Post date:** [February 7, 2019, 2:14am UTC](https://www.finalbuilder.com/forums/t/failover-server/6414/2 "2019-02-07T02:14:45Z")

</div>

Hi Jeremy,

We don’t have any in-built fail-over server functionality.

Probably the simplest option would be to run your server in a virtual machine and use [virtual machine replication](https://social.technet.microsoft.com/wiki/contents/articles/36705.hyper-v-replica-step-by-step-virtual-machine-replication.aspx) to update an identical slave virtual machine.

It is also possible to replicate the database. This would require managing separate primary and standby database servers rather than using the bundled PostgreSQL database server. These can either be PostgreSQL or SQL Server - both of which support replication. See [PostgreSQL: High Availability, Load Balancing, and Replication](https://www.postgresql.org/docs/9.6/high-availability.html) or [SQL Server Replication](https://docs.microsoft.com/en-us/sql/relational-databases/replication/sql-server-replication?view=sql-server-2017)

Once you have a fail-over database, you should be able to run a Continua CI install on another server and point it at that database. Make sure you have a backup of the server configuration file `C:\Program Files\VSoft Technologies\ContinuaCI\Server\Continua.Server.Service.exe.config` which contains the encryption keys which you will need to copy to the new install. The new server will not have a copy of the build logs. If you need these, make sure you have a synchronised copy of the `ws` folder under the under the data share folder. The new server will also not have the repository caches, but these will be rebuilt when the server starts. This may take some time so it would be useful to have a synchronised copy of the `rc` folder under the data share folder.

---

<div class="post-metadata">

**Author:** ![cm.vienna](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/c/f05b48/32.png) [@cm.vienna](https://www.finalbuilder.com/forums/u/cm.vienna)\
**Post date:** [October 12, 2019, 10:08pm UTC](https://www.finalbuilder.com/forums/t/failover-server/6414/3 "2019-10-12T22:08:07Z")

</div>

hi there, well to have a node for failover of the application would be nice - however one could realize that using a windows failover cluster and binding the ContinuaCI site to the core IP or a role IP.  
but the more inconvenient issue is that the property “connection.connection\_string” obviously does not understand the key “Failover Partner” for an MSSQL connectionstring - how can that be assuming the app is using an SQL native client?

---

<div class="post-metadata">

**Author:** ![Sparky](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/sparky/32/10_2.png) [@Sparky](https://www.finalbuilder.com/forums/u/Sparky)\
**Post date:** [October 14, 2019, 1:34am UTC](https://www.finalbuilder.com/forums/t/failover-server/6414/4 "2019-10-14T01:34:36Z")

</div>

Hi @cm.vienna,

We don’t have database mirroring set up at the moment so we can’t really test this without allocating significant time and resources. Can you let us know what you are seeing which suggests that “Failover Partner” is not understood?

Continua CI uses NHibernate as its data access layer for most database queries and updates. It also uses Dapper in some cases where performance is required. Both NHibernate and Dapper use an ADO SqlConnection which should support a Failover Partner.

We’re not experts on SQL Server replication, but as far as we know it should work providing that mirroring is configured correctly on the database servers. Which version of SQL Server are you using? Are you using mirroring or always on availability groups?

---

<div class="post-metadata">

**Author:** ![cm.vienna](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/c/f05b48/32.png) [@cm.vienna](https://www.finalbuilder.com/forums/u/cm.vienna)\
**Post date:** [October 14, 2019, 6:40am UTC](https://www.finalbuilder.com/forums/t/failover-server/6414/5 "2019-10-14T06:40:26Z")

</div>

hi Sparky, thanks for your reply … and i have to apologize.  
having updated ContinuaCi a few weeks ago to 1.19.1.405 (from some older version installed end of 2014) i just copied the connectionstring from the older installation. just now i tried the (initially not working) “Server=10.10.0.x;Failover Partner=10.10.0.y;Database=continuaCi;User ID=_ **;Password=** _\*\*;” and voilá - everything appears to work as expected (after restarting the ContinuaCI service).

IIRC the error message was something like “the SQL instance you are trying to connect is acting as mirror and cannot be accessed” - SQL are 2012 standard (meanwhile SP4) configured as failover on two nodes on a W2012 failover cluster.

again, thanks for taking care and maintaining ContinuaCI

---

<div class="post-metadata">

**Author:** ![Sparky](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/sparky/32/10_2.png) [@Sparky](https://www.finalbuilder.com/forums/u/Sparky)\
**Post date:** [October 14, 2019, 7:11am UTC](https://www.finalbuilder.com/forums/t/failover-server/6414/6 "2019-10-14T07:11:10Z")

</div>

Great to hear that you’ve now got it working.
