Microsoft SQL Server Requirements for Salesforce
To have a local copy of the Salesforce data, you can install Microsoft SQL Server. You can also use an Amazon RDS SQL server or an Azure SQL server. 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.
When you want 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 get filled 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.
Amazon RDS SQL Server
You can use an Amazon RDS SQL server instance for backup and restore operations (Sync DB option) as long as you can access the Amazon RDS instance from your internal network.
Azure SQL Server
You can use an Azure SQL server backup and restore operations (Sync DB option) as long as you can access the Azure SQL server from your internal network.
Last modified: 7/15/2019 4:18:00 PM