Blog

What is a Salesforce Sandbox?

Although it is very easy and possible to make changes directly to configuration in Salesforce, it is a better idea to test out those changes in another environment which won’t affect your users. That’s why Salesforce includes a ‘sandbox’ for every production organisation where changes can be made and tested before moving them to production. This type of environment is called a sandbox. The number of sandboxes you can create and the types available depend on which edition you have, some come standard and some are available for an extra cost.

Each production organisation can have one or more sandboxes attached to it and they can be of different types. For example, most larger organisations will have at least 3 environments, a development environment, a test environment and a production environment. To cater for this, you would use sandboxes for the development and test environments. Changes can be developed in the development environment, tested in the test environment and when you are confident that the changes won’t break existing functionality, they can be moved into the production environment using changesets. It is also useful to use sandboxes to evaluate Apps from the AppExchange.

salesforce-environments

Refresh:
A refresh allows you to copy configuration, code and data (depending on the type of sandbox) from the production organisation into a sandbox. This is useful when you first create a new sandbox and you have an existing production organisation, so that you make sure the environments are in sync. It is also useful to do a a refresh of a full copy sandbox from time to time, to make sure that the data is in sync with production, so that you can be confident that the testing that is done is done on production data and there won’t be any surprises when the changes are moved into production. A refresh will replace an existing sandbox with a new copy.

Developer Sandbox
A developer sandbox is for developing new functionality, configuration and code and testing it. Multiple users can login to a developer sandbox. In the past they were limited to 10MB of test and sample data which was very limiting, but Salesforce has increased this to the current limit of 200MB. You can refresh the configuration from production although it will not copy any data. It can be refreshed once a day.
Developer Pro sandbox
A Developer Pro sandbox is similar to a Developer sandbox, in that it contains a copy of of all production organisation configuration, and no data is copied across. The difference is in the amount of data and file storage, it has a higher limit of 500MB, which will be enough for many organisations to load enough data to test production scenarios. It can also be refreshed once a day.
Partial Copy sandbox
The partial copy sandbox is a new addition to the type of sandboxes that Salesforce offers. It offers a high 5GB of data and file storage. The difference between the full copy and partial copy is that the partial copy allows you to use templates to define the data that will be copied (e.g. select the objects). Up to 10,000 records per objects will be copied across. As well as standard and custom object records, it will also copy documents and attachments. The refresh interval is shorter than the full copy at 5 days. The partial copy sandbox is attractive as it is cheaper than a full copy, can be refreshed much more frequently and if you do not have a high volume of data will allow you to have all or most of the data copied across.
Full Copy Sandbox
The full copy sandbox is a copy of the entire production setup, including configuration, data, documents and attachments. It is usually used for UAT (user acceptance testing) for new or changed functionality before it is moved into production. It is also used for troubleshooting issues that occurred in production. As it does a complete copy of everything, Salesforce limits the refresh interval to 29 days.


Type Purpose Storage Limit Data Refresh
Developer Development and configuration of new functionality 200MB Data storage
200MB File storage
Configuration only 1 day
Developer Pro Development where larger amounts of data are needed to test functionality 1GB Data storage
1GB File storage
Configuration only 1 day
Partial Copy Testing or Training where a subset of the data is sufficient 5GB Data storage
5GB File storage
Subset of data determined by template 5 day
Full Copy Testing in an environment that is identical to production Same as Production All Data 29 days



Notes:

  • Sandboxes will have a different organisation id to your production organisation
  • Salesforce record Ids are copied over for full copy sandboxes
  • When you create or refresh a sandbox, the status will be have the status ‘Copying’. Once done the status will change to ‘Ready for Use’. The copy time depends on the amount of data and may take from a few minutes to a number of hours.
  • To login to a Sandbox after a refresh, use https://test.salesforce.com. Salesforce automatically appends the sandbox name to any users tha are copied over. e.g. if the new Sandbox name is ‘fullcopy’, then the user [email protected] will become [email protected]. The password remains the same.
  • You may notice that emails are not been sent from a new sandbox. This is because Salesforce sets the email deliverability to ‘System Email Only’ to prevent emails being accidentally sent from your test environments to outside contacts. This can be changed within the Email Deliverability settings.
  • Developer edition doesn’t have change sets

What Certification are you studying for now?

Focus on Force currently provides practice exams and study guides for sixteen certifications

Salesforce Sandboxes

What is a Salesforce Sandbox? Although it is very easy and possible to make changes directly to configuration in Salesforce, it is a better idea to test out those changes in another environment which won’t affect your users. That’s why Salesforce includes a ‘sandbox’ for every production organisation where changes can be made and tested before moving them to production. This type of environment is called a sandbox. The number… Read More

Salesforce Sandboxes

Salesforce Quotes

Once you have added your products into an opportunity, Salesforce has inbuilt functionality to allow you to generate and email quotes to customers. Lets take a look at how this works, and what you need to be aware of when using Salesforce Quotes. First, to use Quotes they need to be enabled. By default the are not enabled and you won’t see them in your Opportunity screen. Go to: Setup… Read More

Salesforce Quotes

Salesforce Jobs

Salesforce Administrator After Salesforce is implemented, a Salesforce administrator is required to maintain and extend the system functionality as business needs change, evolve or expand into new areas of the business. The role is a varied one but will typically include some or all of the following: • Provide User Support and be responsible for user administration • Investigate and resolve problems • Investigate and analyze requests for change and… Read More

Salesforce Jobs

Salesforce Basic Terminology

If you are new to the Salesforce.com application, you may wonder ‘What exactly is Salesforce.com’ and before long you will come across some terminology that is used to describe different parts of the application, functionality and navigation.Here is a quick guide to some of the basic terminology you need to understand Salesforce.com and navigate the application.Basic SalesforceSalesforce is the name of the company and name of the application. It started… Read More

Salesforce Basic Terminology

Subtract Two Date Fields to Calculate Duration of Time

If you are faced with the challenge of calculating the duration of time between two dates in Salesforce, this post is for you. Lets say what you want is to take two dates and times, for example 20/01/2014 09:00am and 21/01/2014 10:20am and calculate the duration of time between them in hours and minutes, and display the result like this: 24:20 or 24h:20m.If we just create a formula field and… Read More

Subtract Two Date Fields to Calculate Duration of Time

Salesforce Roll-up Summary Using the Value of a Formula Field

Roll-up summary fields are a very useful Salesforce feature, but you may come across a situation where you need to rollup the value of a formula field. Here is an example: You have added a custom field to the Product object to record the cost of a product. You want the total cost of all products added displayed on an opportunity. In the screenshot below you can see Widget A… Read More

Salesforce Roll-up Summary Using the Value of a Formula Field

Saving Emails to Salesforce

If you use Gmail or another web based email service, Salesforce has a feature that will allow you to save your emails related to leads, contacts and open opportunities. It is the ‘Email to Salesforce’ features and when enabled, allows users to bcc a unique bcc email address to automatically create activity records against records in Salesforce. To use this feature, firstly the Salesforce Administrator has to enabled it, and… Read More

Saving Emails to Salesforce

Comparing Salesforce Editions

There are a number of editions of Salesforce offering varying features and capabilities. If you are new to Salesforce and deciding which edition is right for you, then this guide will be helpful. If you already have Salesforce it will be useful to know what features you can take advantage of and any limitations you will have. It is of course possible to upgrade to a higher edition. If you… Read More

Comparing Salesforce Editions

Salesforce Search Layouts

Salesforce gives up the ability to customize many areas of how it displays data. One area that is important to understand but easy to overlook is search layouts. Search layouts allow us to customize the fields both standard and custom that are displayed in various results lists. It is worth the time to customize, as it can improve productivity by ensuring that the most useful fields are displayed in the… Read More

Salesforce Search Layouts

Salesforce Instances vs Orgs vs Environments

Once you start getting involved with Salesforce, you will hear a number of terms such as Instance, Org, Environment and even POD. Its easy to get these confused or even not to even be aware of what they really mean. One person may refer to the development instance and another the development environment. Some organisations may refer to the fact that they have multiple instances of Salesforce, and another multiple… Read More

Salesforce Instances vs Orgs vs Environments

What is the Salesforce Account Hierarchy (And How To Use it)

The Salesforce account hierarchy allow accounts to be related in a hierarchy by using a ‘parent account’ field to link them together. Once linked, the complete hierarchy structure can be viewed and links are provided to navigate directly to the accounts.The first step is to create or identify the ultimate ‘Parent’ account. This is the account at the top of the hierarchy. In our example, the top level account is… Read More

What is the Salesforce Account Hierarchy (And How To Use it)

Data Loader Tips – Inserting or Updating Blank Values in a Field

You may have come across the situation where you need to use Dataloader to clear or delete the value of a field. Normally, if you provide a blank value in the input file, DataLoader will ignore it and leave the field value as is. Lets look at an example. Here we have loaded data into the Product Description field instead of the Product Code field. Lets imagine, instead of 3… Read More

Data Loader Tips – Inserting or Updating Blank Values in a Field

Salesforce Multicurrency – What You Need to Know

      What is Salesforce multicurrency?Before we look at how multicurrency works and what you need to look out for, lets look at what it offers:Adds the ability to record amounts in different currencies. If you don’t have multicurrency enabled, then amounts are just displayed as an amount.Allows amounts to be converted, displayed and reported according to exchange ratesAllows the use of dated exchange rates so the value at… Read More

Salesforce Multicurrency – What You Need to Know

Preventing Duplicate Records with Salesforce Config

The Salesforce mantra is ‘clicks not code’ so we always look for a config solution to a problem before resorting to code. While we can set the unique indicator on a custom field to prevent duplicate values for one field across records, how do we prevent records inserted with duplicate values across all or some of the fields? Do we need to write a trigger to handle this? Or is… Read More

Preventing Duplicate Records with Salesforce Config