Working with SQL Server snapshots

This section lists the steps to take a snapshot and delete the same.

Taking a snapshot creates a new snapshot entry in the Oracle dSource’s Timeflow. You can use either Snapshot (Default) or Snapshot with Parameters option for taking the snapshot.

Snapshot (Default) 

Perform the following steps to take a snapshot:

1. Login to the Delphix Management application.

2. Click Manage and select Datasets from the dropdown list.

3. Select the dSource you want to Snapshot.

4. Click the Camera icon. Alternatively, click the arrow next to the Camera icon and select Snapshot (default).

5. From the Snapshot dialog box, select Yes.

6. Navigate to the Timeflow tab and click View: All snapshots to verify the Snapshot you just created.

7. To delete the snapshot, select the snapshot you just created, and from the Actions menu (...), select Delete Snapshot.

8. From the Delete Snapshot dialog box, select Delete.

9. Navigate to the Timeflow tab and click View: All snapshots to verify the snapshot you just deleted.

Snapshot with Parameters

Perform the following steps to take a snapshot:

1. Login to the Delphix Management application.

2. Click Manage and select Datasets from the dropdown list.

3. Select the dSource you want to Snapshot.

4. Click the arrow next to the Camera icon and select the Snapshot with Params... option.

5. From the Snapshot dialog box, select one of the following:

   1. Force Full Backup - If you select this option, then the Delphix Engine will perform an incremental backup by default. You must select this option only when a full backup is required. Full and Incremental backups consume the same space on the Delphix Engine. 

   2. Double Sync - Selecting this option will perform a SnapSync operation as normal. After the first SnapSync is successful, the Engine will immediately perform a second SnapSync without waiting for the Log Files required for the first SnapSync to be made consistent. This is most useful when performing the initial SnapSync ( or when "Force Full Backup" is selected ) on a very large database that would lead to a large number of archive logs being required to make the SnapSync consistent. Provisioning from a SnapSync that requires excessive recovery is typically time-consuming.

   3. Do Not Resume - If a failure is encountered during the initial SnapSync, the Delphix Engine can resume the SnapSync at a later date. This option will cause the engine to not resume, but rather to start the initial SnapSync over again.

6. Navigate to the Timeflow tab and click View: All snapshots to verify the Snapshot you just created.

7. To delete the snapshot, select the snapshot you just created, and from the Actions menu (...), select Delete Snapshot.

8. From the Delete Snapshot dialog box, select Delete.

9. Navigate to the Timeflow tab and click View: All snapshots to verify the snapshot you just deleted.