Details of the components of the SQL Database Server

Name	Version	Comments
Operating System	Windows 2012 - 64 bit Windows 2012 R2 - 64 bit Windows 2016 - 64 bit Windows 2019 - 64 bit	Datacenter or Standard Datacenter or Standard Standard Standard
SQL Server	SQL 2012 Enterprise or Standard+ SP1/SP2/SP3/SP4 - 64 bit SQL 2014 Enterprise or Standard SP1 - 64 bit SQL 2014 Enterprise or Standard SP2 - 64 bit SQL 2014 Enterprise or Standard SP3 - 64 bit Note: You can restore IRC database from the Enterprise edition of the SQL server to the Standard edition. Refer to Restoring database from Enterprise edition of the SQL server to the Standard edition section for details.	The following features need to be installed: Instance Features Database Engine Services Full Text and Semantic Extractions for Search [2014] Full Text and Semantic Extractions for Search [2012] Full Text Search [2008 R2] Reporting Services – Required for Reporting Server Shared Features Business Intelligence Development Studio [2008 R2] Client Tools Connectivity Client Tools Backward Compatibility Client Tools SDK Documentation Components Management Tools - Basic Management Tools – Complete SQL Client Connectivity SDK Collation Collation set to the default value at install: ‘Dictionary order, case-insensitive, for use with 1252 character Set’, which equals the ‘SQL_Latin1_General_CP1_CI_AS’ Mode Native Mode / Compatibility Level (level 120)[2014] Native Mode / Compatibility Level (level 110) [2012] Native Mode / Compatibility Level (level 100) [2008 R2] Size The recommended initial size for CoreDB database is – IRC Database data file (mdf): 20GB IRC Database log file (ldf) : 2GB. ldf, 10% auto growth and recovery model as simple Note: The IRC Database size is set by default during IRC activation. tempdb Minimum requirement for SQL tempdb: 8 GB Minimum Requirement for ldf: 2GB. ldf, 25% auto growth for data file and 20% for log files with recovery model as simple.
SQL 2016 SP1/SP2 Standard or Enterprise Edition 64-bit Note: For Clustered support, you must use the SQL 2016 SP1 Enterprise Edition 64 bit.	The following features need to be installed: Instance Features Database Engine Services Full Text and Semantic Extractions for Search Reporting Services Native– Required for Reporting Server Shared Features Client Tools Connectivity Client Tools Backward Compatibility Client Tools SDK Documentation Components SQL Client Connectivity SDK Microsoft SQL Server Management Studio must be deployed. For details, see https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms Note: This feature is recommended to help the IRC administrators configure and administer components within the IRC database server. However, even without deploying the Microsoft SQL Server Management Studio in the IRC database server, IRC will continue to work. Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013 https://www.microsoft.com/en-in/download/confirmation.aspx?id=42313 Collation Collation set to the default value at install:‘Dictionary order, case-insensitive, for usewith 1252 character Set’, which equals the‘SQL_Latin1_General_CP1_CI_AS’ Mode Native Mode / Compatibility Level for SQL Server 2017 is 140 Native Mode / Compatibility Level for SQL Server 2019 is 150 Size The recommended initial size for CoreDBdatabase is – IRC Database data file (mdf): 20GB IRC Database log file (ldf) : 2GB. ldf,10% auto growth and recovery model as simple Note: The IRC Database size is set by default during IRC activation. tempdb Minimum requirement for SQL tempdb:8 GB Minimum Requirement for ldf: 2GB. ldf,25% auto growth for data file and 20%for log files with recovery model as simple
SQL 2017 CU20 Standard or Enterprise Edition - 64 bit SQL 2019 CU4 Standard or Enterprise Edition - 64 bit	The following features need to be installed: Instance Features Database Engine Services Full Text and Semantic Extractions for Search Reporting Services Native Note: A separate reporting services installer is available for SQL 2017 and 2019. Shared Features Client Tools Connectivity Client Tools Backward Compatibility Client Tools SDK Documentation Components SQL Client Connectivity SDK Microsoft SQL Server Management Studio must be deployed. For details, see https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms Note: This feature is recommended to help the IRC administrators configure and administer components within the IRC database server. However, even without deploying the Microsoft SQL Server Management Studio in the IRC database server, IRC will continue to work. Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013 https://www.microsoft.com/en-in/download/confirmation.aspx?id=42313 Collation Collation set to the default value at install:‘Dictionary order, case-insensitive, for usewith 1252 character Set’, which equals the‘SQL_Latin1_General_CP1_CI_AS’ Mode Native Mode / Compatibility Level (level130) Size The recommended initial size for CoreDBdatabase is – IRC Database data file (mdf): 20GB IRC Database log file (ldf) : 2GB. ldf,10% auto growth and recovery model as simple Note: The IRC Database size is set by default during IRC activation. tempdb Minimum requirement for SQL tempdb:8 GB Minimum Requirement for ldf: 2GB. ldf,25% auto growth for data file and 20%for log files with recovery model as simple

Operating System

Windows 2012 - 64 bit

Windows 2012 R2 - 64 bit

Windows 2016 - 64 bit

Windows 2019 - 64 bit

Datacenter or Standard

Standard

SQL Server

SQL 2012 Enterprise or Standard+ SP1/SP2/SP3/SP4 - 64 bit

SQL 2014 Enterprise or Standard SP1 - 64 bit

SQL 2014 Enterprise or Standard SP2 - 64 bit

SQL 2014 Enterprise or Standard SP3 - 64 bit

Note: You can restore IRC database from the Enterprise edition of the SQL server to the Standard edition. Refer to Restoring database from Enterprise edition of the SQL server to the Standard edition section for details.

The following features need to be installed:

Instance Features

Database Engine Services
- Full Text and Semantic Extractions for Search [2014]
- Full Text and Semantic Extractions for Search [2012]
- Full Text Search [2008 R2]
Reporting Services – Required for Reporting Server

Shared Features

Business Intelligence Development Studio [2008 R2]
Client Tools Connectivity
Client Tools Backward Compatibility
Client Tools SDK
Documentation Components
Management Tools - Basic
- Management Tools – Complete
SQL Client Connectivity SDK

Collation

Collation set to the default value at install: ‘Dictionary order, case-insensitive, for use with 1252 character Set’, which equals the ‘SQL_Latin1_General_CP1_CI_AS’

Mode

Native Mode / Compatibility Level (level 120)[2014]
Native Mode / Compatibility Level (level 110) [2012]
Native Mode / Compatibility Level (level 100) [2008 R2]

Size

The recommended initial size for CoreDB database is –
- IRC Database data file (mdf): 20GB
- IRC Database log file (ldf) : 2GB. ldf, 10% auto growth and recovery model as simple
Note: The IRC Database size is set by default during IRC activation.

tempdb

Minimum requirement for SQL tempdb: 8 GB
Minimum Requirement for ldf: 2GB. ldf, 25% auto growth for data file and 20% for log files with recovery model as simple.

SQL 2016 SP1/SP2 Standard or Enterprise Edition 64-bit

Note: For Clustered support, you must use the SQL 2016 SP1 Enterprise Edition 64 bit.

The following features need to be installed:

Instance Features

Database Engine Services
- Full Text and Semantic Extractions for Search
Reporting Services Native– Required for Reporting Server

Shared Features

Client Tools Connectivity
Client Tools Backward Compatibility
Client Tools SDK
Documentation Components
SQL Client Connectivity SDK
Microsoft SQL Server Management Studio must be deployed. For details, see https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
Note: This feature is recommended to help the IRC administrators configure and administer components within the IRC database server. However, even without deploying the Microsoft SQL Server Management Studio in the IRC database server, IRC will continue to work.
Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013 https://www.microsoft.com/en-in/download/confirmation.aspx?id=42313

Collation

Collation set to the default value at install:‘Dictionary order, case-insensitive, for usewith 1252 character Set’, which equals the‘SQL_Latin1_General_CP1_CI_AS’

Mode

Native Mode / Compatibility Level for SQL Server 2017 is 140
Native Mode / Compatibility Level for SQL Server 2019 is 150

Size

The recommended initial size for CoreDBdatabase is –
- IRC Database data file (mdf): 20GB
- IRC Database log file (ldf) : 2GB. ldf,10% auto growth and recovery model as simple
  Note: The IRC Database size is set by default during IRC activation.

tempdb

Minimum requirement for SQL tempdb:8 GB
Minimum Requirement for ldf: 2GB. ldf,25% auto growth for data file and 20%for log files with recovery model as simple

SQL 2017 CU20 Standard or Enterprise Edition - 64 bit
SQL 2019 CU4 Standard or Enterprise Edition - 64 bit

The following features need to be installed:

Instance Features

Database Engine Services
- Full Text and Semantic Extractions for Search
Reporting Services Native
Note: A separate reporting services installer is available for SQL 2017 and 2019.

Shared Features

Client Tools Connectivity
Client Tools Backward Compatibility
Client Tools SDK
Documentation Components
SQL Client Connectivity SDK
Microsoft SQL Server Management Studio must be deployed. For details, see https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
Note: This feature is recommended to help the IRC administrators configure and administer components within the IRC database server. However, even without deploying the Microsoft SQL Server Management Studio in the IRC database server, IRC will continue to work.
Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013 https://www.microsoft.com/en-in/download/confirmation.aspx?id=42313

Collation

Collation set to the default value at install:‘Dictionary order, case-insensitive, for usewith 1252 character Set’, which equals the‘SQL_Latin1_General_CP1_CI_AS’

Mode

Native Mode / Compatibility Level (level130)

Size

The recommended initial size for CoreDBdatabase is –
- IRC Database data file (mdf): 20GB
- IRC Database log file (ldf) : 2GB. ldf,10% auto growth and recovery model as simple
  Note: The IRC Database size is set by default during IRC activation.

tempdb

Minimum requirement for SQL tempdb:8 GB
Minimum Requirement for ldf: 2GB. ldf,25% auto growth for data file and 20%for log files with recovery model as simple