Secret Server supports SQL database mirroring to create a real-time backup of all the stored data.
Configure your SQL database with a primary, secondary and witness server to set up automatic failover. With SQL mirroring and automatic failover, Secret Server offers high availability and data redundancy. A hot backup of the web server and database aids in disaster recovery and limits down time of a vital instance. Database mirroring is configured in SQL Server and the failover partner is specified in the advanced setting in Step 3 of the Installer.
For more information read: SQL Server Mirroring