DB size reduced after refreshing environment

book

Article ID: 222191

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

After a database refresh from the PPM PROD database environment, the size is shown in the NON PROD with smaller size.

Is there any data that is not transferred from Prod to Non-Prod? What causes this difference in size of both DBs?

Environment

Clarity PPM 15.x

Resolution

The reduction of the size when doing the refresh is expected. The data is the same, but the size of the DB smaller.

The reason is the size of the tables will be reduced as it ignores bloat on tables while performing backup and restore activities. So, this is expected.