Where are the diff's for clones stored in SQL Clone.

larrys

Where are the diff's for clones stored in SQL Clone? I see the vhd's pointing back to the image, but where are the pages that get changed stored on the local server?

DanC

Hi @larrys

The diffs are stored in a VHD called the differencing VHD or just 'diff file for each clone according to the docs below: https://documentation.red-gate.com/clone/getting-started/how-sql-clone-works

For further information, a clone VHD differencing disk basically contains:

a) the physical path to the parent image, like \\server\share\images\myimage 
b) the contents of any changed blocks compared with the image (plus an index)

Hope this helps answer your question!

larrys

Thanks Dan, I saw it change after an update and checkpoint. Appreciate it.