Wind-formed ripples across sand

Photo: Greg Bulla / Unsplash

Guide

Salesforce sandbox types and strategy: which sandboxes you need and how to use them

The four Salesforce sandbox types, what each copies, storage and refresh limits, a sandbox setup for small and larger teams, refresh and data-masking rules, and the mistakes that make testing unreliable.

Salesforce offers four sandbox types. Developer and Developer Pro sandboxes copy your configuration but no data and can be refreshed daily. Partial Copy sandboxes add a sample of production data and refresh every 5 days. Full sandboxes copy all data and refresh every 29 days. Most companies need at least one developer-type sandbox for building and one data-bearing sandbox for testing and user acceptance, with a clear rule for what moves between them and when each one is refreshed.

What are the four sandbox types?

Salesforce sandbox types (from Salesforce Help)
TypeWhat it copiesData storageRefresh intervalBest for
DeveloperConfiguration and code only200 MB data, 200 MB files1 dayBuilding and trying changes, admin experiments
Developer ProConfiguration and code only1 GB data, 1 GB files1 dayDevelopment and QA that need loaded test data
Partial CopyConfiguration plus a sample of production data defined by a sandbox template5 GB data, files equal to production5 daysIntegration testing and realistic QA
FullConfiguration and all production dataSame as production29 daysUser acceptance testing, performance testing, training

How many of each you get depends on your edition and contract. Salesforce's new Core, Advanced and Max editions list sandbox entitlements on their pricing pages, and those listings vary by cloud, so confirm what your contract includes before planning around a Full sandbox.

What sandbox setup does a typical team need?

Match the setup to how many people change the org and how risky the changes are.

  • One admin making configuration changes: a Developer sandbox for building and a Partial Copy or Full sandbox for testing with real-looking data before go-live.
  • A small team with a partner: a Developer sandbox per builder, a shared Developer Pro or Partial Copy for integration testing, and a Full sandbox for user acceptance.
  • Larger programs with integrations and releases: individual Developer sandboxes, an integration sandbox connected to test versions of the ERP or other systems, a Full sandbox for user acceptance and training, and a documented path from one to the next.

How often should you refresh?

Refresh developer sandboxes whenever someone starts a new piece of work, so they build against current configuration. Refresh testing sandboxes at the start of each release cycle, after the previous release reaches production. Refreshing a Full sandbox mid-test wipes whatever testers set up, so schedule it and tell people.

  • Keep a sandbox calendar: who owns each sandbox, what it is for and when it next refreshes.
  • Write down post-refresh steps: update integration endpoints, deactivate scheduled jobs and emails that should not run, and reset test users.
  • Check that integrations point at test systems, never at production, after every refresh.

How do you protect personal data in sandboxes?

Partial Copy and Full sandboxes contain real customer data, and sandbox access is usually broader than production access. Mask or remove sensitive fields after refresh, limit who can log in, and make sure email deliverability is set so test runs cannot send messages to real customers. Salesforce offers Data Mask for automated masking; smaller orgs sometimes use a post-refresh script. Either way, treat sandbox data under the same privacy rules as production.

What mistakes make sandboxes useless?

  • Testing in a sandbox that has not been refreshed for months, so it no longer matches production.
  • Building directly in production, which leaves sandboxes behind.
  • Using Developer sandboxes for user acceptance, where testers have no realistic data to work with.
  • Forgetting post-refresh steps, so a test run emails customers or writes to a live ERP.
  • Giving everyone access to Full sandboxes that contain real personal data.

A clear sandbox setup is one of the first things we put in place in managed services engagements, because it is what makes every later release predictable.

Chris Gooding, President & CEO of Abstrakt Solutions
President & CEO, Abstrakt Solutions
LinkedIn →

Tech Talk

A monthly brief for the people who own Salesforce, AI and revenue technology

What changed in Salesforce and AI this month, and what to do about it.

One email a month. Written by the consultants who deliver the work, not by a marketing team, for the leaders who make the technology decisions.

  • What changed in Salesforce, AI, integration and RevOps, and what it means for your org
  • At least one framework, checklist or reference architecture you can take into a meeting
  • Honest opinions, including when we disagree with what a vendor is selling
  • No sales sequence. We do not sell from this list

Consultant analysis, not vendor recaps. One click to leave.

One email a month. Your industry and your address, nothing else. We never share either, and you can unsubscribe from the bottom of any issue. See what’s in Tech Talk →

Call (314) 916-4095 Book a consultation
Call (314) 916-4095 Book a call