High Availability Installation Guide

Back Next

Configure the Microsoft SQL Server Database

If you install

B2B Data Exchange

repositories on a Microsoft SQL Server database, enable the

READ_COMMITTED_SNAPSHOT

database option. If you install the Dashboard and Reports component, enable the

READ_COMMITTED_SNAPSHOT

option on the operational data store as well.

Open an SQL query for the database server with rights to set database options.

Run the following SQL statements:

ALTER DATABASE [<database_name>] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

Run the following SQL query:

ALTER DATABASE <database_name> SET READ_COMMITTED_SNAPSHOT ON

To verify that this option is set, run the following SQL query:

SELECT is_read_committed_snapshot_on FROM sys.databases WHERE name = '<database_name>'

If the option is set, the query returns the value 1. If the option is not set, the query returns the value 0.

Run the following SQL statement to forcefully disconnect all users from the system:

ALTER DATABASE [<database_name>] SET MULTI_USER