Only if the Database/Application is shadow copy or open file backup aware.

Not only does the Parent table in a database have to send edits to temporary storage, but so do all child tables and dependencies which then update the main storage tables after the snapshot complete command is issued.

>Yes, thats exactly what my point is. Dont undertsand open file backup if the backup you get can be wrong or even damaged...
>
>>Hi,
>> Remember, with shadow copy, you don't always get what you want. i.e. datasets can be out of sync.
>>
>>>>>Hi
>>>>>
>>>>>I never really understood open file backup. If a file is open and in use by an application(s) and you do an open file backup, what are you getting? Surely this must result in a file that is not necessarily complete and/or in harmony with associated indexes or even possily corrupted.
>>>>>
>>>>>How does open file backup work?
>>>>
>>>>I haven't totally wrapped my mind around all the details, either, but I believe an example of the techniques involved is the MS Volume Shadow Copy Service:
>>>>
>>>>http://en.wikipedia.org/wiki/Volume_shadow_copy
>>>>http://technet2.microsoft.com/WindowsServer/en/Library/2b0d2457-b7d8-42c3-b6c9-59c145b7765f1033.mspx?mfr=true
>>>
>>>
>>>Thanks Al.