CB Protection SQL Server Configuration v8.1.8

[#1]

Document version: April, 2020

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.

[BFortin]

Change log for CB Protection SQL Server Configuration v8.1.8.pdf (changes since the 8.1.6 version):

1. Page 2: Updated General Performance Note #1.
   • 8.1.6 version: The SQL Server must be exclusively dedicated to the Cb Protection Server. Do not put any other database on this SQL Server instance.
   • 8.1.8 version: The SQL Server must be exclusively dedicated to the Cb Protection Server. Do not put any other databases on this SQL Server instance, nor any other SQL Server instances on the server.
2. On page 9: Updated reasons why database size is calculated differently for different deployment sizes:
   • 8.1.6 version: SQL Server Standard edition does not provide SQL database compression.
   • 8.1.8 version: SQL Server Standard edition prior to SQL Server 2016 SP1 does not provide SQL database compression.
3. Minor editing and formatting changes were made that had no impact on content meaning.