CB Protection v8.1.6 SQL Server Configuration

[#1]

CB Protection uses a single SQL database named “das”. This database will be created on the SQL server once you install the CB Protection Server.

This document describes some of SQL best practices as well as pre- and post-installation tasks that are necessary to ensure proper database operation.

Most of the database queries described in this document require sysadmin privileges on the SQL Server.

Important: This document is a supplement to the CB Protection Operating Environment Requirements document for your release, called the “OER” through most of this document. Information in the OER is necessary for successful completion of the tasks in this document, so you should have both documents with you when performing the tasks described here.

See the Comments below for changes in this version.

[triordan]

Change log for the December 2019 CB Protection 8.1.6 SQL Server Configuration Guide (changes since the 8.1.4 version):

1. Windows Server 2019 was added to the list of supported operating Systems.
2. The SQL Configuration table under "SQL Server Memory Configuration" was updated. For the "2,001 – 5,000 endpoints" endpoints row, it previously listed 28 GB as the recommendation. This has been lowered 27 GB to match the OER document and OER health indicator.
3. In the "Test Prerequisites" section, corrections and clarifications were made to the description of .NET Framework requirements.