# SQL Server Fail over

**URL:** <https://forum.inductiveautomation.com/t/sql-server-fail-over/3284>\
**Category:** Ignition\
**Created:** [September 14, 2011, 11:32am UTC](https://forum.inductiveautomation.com/t/sql-server-fail-over/3284 "2011-09-14T11:32:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kevinmarchand](https://avatars.discourse-cdn.com/v4/letter/k/439d5e/32.png) [@kevinmarchand](https://forum.inductiveautomation.com/u/kevinmarchand)\
**Post date:** [September 14, 2011, 11:32am UTC](https://forum.inductiveautomation.com/t/sql-server-fail-over/3284/1 "2011-09-14T11:32:57Z")

</div>

Hi,  
It would be nice to fail over another sql server and not a database on the same sql server.

thanks

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [September 14, 2011, 2:48pm UTC](https://forum.inductiveautomation.com/t/sql-server-fail-over/3284/2 "2011-09-14T14:48:28Z")

</div>

You can do that right now. You just need to create two database connections to separate SQL servers. That way you can fail over to a different connection altogether.