Cb Protection v8.1.4 SQL Server Configuration

[#1]

Document Version: 8.1.4 (July 2019)

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 August 2018 Cb Protection 8.1.0 GA SQL Server Configuration Guide (changes since latest 8.0.0 version):

1. The names of Cb Protection services were updated to the current names from the obsolete "Bit9" naming.
2. Other minor corrections and improvements were made.

[lhowarth]

Change log for the July 2019 CB Protection 8.1.4 SQL Server Configuration Guide

1. Updated the SQL Configuration doc table under "SQL Server Memory Configuration" for the "2,001 – 5,000 endpoints" endpoints row. It previously listed 28 GB as the recommendation, lowered that to 27 GB to match the OER document and OER health indicator.

[lhowarth]

Change log for the July 2019 (update 2) CB Protection 8.1.4 SQL Server Configuration Guide

1. Updated "Choosing Proper Hardware for the SQL Server" to include Windows Server 2019 support.