Failsafe support for SQL databases

Kaspersky Security supports the following failsafe technologies for SQL databases:

• Failover Clustering. Supported automatically.
• Database Mirroring. Supported automatically.
• Log Shipping. When the database used by the application (primary database) fails, the server hosting the restored database needs to be specified manually in order to switch to this database.

Using Database Mirroring technology

If your SQL server is configured to use the Database Mirroring failover support technology, the application automatically switches from the primary database that has failed to a mirror database, and then back to the primary database after it has been restored.

If the SQL server is running in High Performance Mode or High Safety Mode Without Automatic Failover for Database Mirroring, manual switchover to Database Mirroring is required by means of the SQL server if the main database used by Kaspersky Security fails.

Using Log Shipping technology

If your SQL server is configured to use the Log Shipping failover support technology, you can switch to using a restored database when the primary database fails. This switch is performed manually.

To switch to the restored database when using Log Shipping technology:

1. In the folder <Application installation folder>\Configuration, open the file BackendDatabaseConfiguration.config in a text editor.
2. Specify the name of the SQL server (indicating the SQL server instance) that hosts the failover partner in the line <SqlServerName>SQL server name\instance</SqlServerName>.
3. Save the file.

   The changes will take effect within one minute.

If Kaspersky Security is installed on a SharePoint farm, the corresponding changes to the file BackendDatabaseConfiguration.config need to be made on all SharePoint farm servers.