Microsoft SQL Server Requirements for Salesforce
You can store your Salesforce data in a Microsoft SQL Server database that you can access from the internal network. You can also use an Amazon RDS SQL server or an Azure SQL server. Configure a database if you need a local copy of the Salesforce data or if you want to use any of the following features:
- Record-level restores
- Restore to the Salesforce cloud
- Sandbox seeding
- Object comparisons
Each Salesforce organization needs a separate database. For example, if you back up two production organizations and one sandbox organization and need a local copy of all three, configure three databases.
The Commvault Salesforce application connects to a database with default options such as connection timeout, host, instance, and so on. If your setup requires additional connection properties, configure the sf_dbConnectionProperties additional setting.
To store your Salesforce data in a local Microsoft SQL Server database, the database must meet the following requirements:
- The Microsoft SQL Server version must be 2008 R2 or higher.
- The Microsoft SQL Server host must have free space that is at a minimum equal to double the size of the Salesforce used data storage. This number accounts for the Salesforce data change frequency because the database maintains all versions.
- The Microsoft SQL Server host must have a minimum of 8 CPUs/processors and 16GB of memory. We recommend that you have 32GB of memory.
- To prevent the Microsoft SQL Server host memory from filling up, set the max server memory limit for the SQL server. For more information, see the Microsoft SQL Server article, Server Memory Server Configuration Options.
- Best Practice: Use the SQL Simple Recovery Model for the SQL database so that the disk does not fill up with transaction logs during backup operations.
- You must have a SQL authentication user.
- For operations that restore data from the Microsoft SQL database, such as record-level restores, the database must be accessible from the Web Server.
Microsoft SQL Servers that use the Always On availability groups feature are supported.
Amazon RDS SQL Server
You can use an Amazon RDS SQL server instance for backup and restore operations if you can access the Amazon RDS instance from your internal network.
Azure SQL Server
You can use an Azure SQL server for backup and restore operations if you can access the Azure SQL server from your internal network.
Last modified: 5/13/2020 6:05:55 PM