Home > Workload Solutions > SQL Server > White Papers > SQL Server 2019 Containers on Linux > Step 5: Modify database data and protect the database state
After provisioning the AdventureWorks database, the developer modifies the database data.
The following figure shows the data before it is modified:
Figure 11. Data before modification
Here is the T-SQL that the developer uses to modify the table data:
Figure 12. T-SQL used to modify data
The following figure shows the data after it is modified:
Figure 13. Modified data
Before releasing the modified environment to the test team, the developer uses XtremIO Virtual Copies to protect the state of the database. XtremIO X2 data reduction services ensure that only unique data is written to the database copy after the snapshot is taken and saved to the array. Also, the unique data that is managed by the snapshot feature is compressed, which further reduces the capacity footprint. Thus, under most circumstances, the XtremIO X2 Virtual Copies snapshot of the database takes little additional storage space and can be both created and destroyed quickly.
The developer reviews the following XtremIO X2 screen to verify the existence of the XtremIO Virtual Copies snapshot of the AdventureWorks database:
Figure 14. Snapshot of the AdventureWorks database shown in XtremIO