dkeith2 wrote:

> Since nbackup locks a db and causes a delta file to be created
> and written to for the duration of the file lock, would it be
> possible/feasible in an OLTP environment to:
>
> Lock a file using nbackup
>
> Backup the file using gbak
>
> Restore the file using gbak, overwriting the original file
>
> Unlock the file using nbackup, causing the delta file to be merged
>

That's a cute idea, but it's not going to work. Nbackup is a physical
copy = page by page. Gbak is a logical copy, record by record. When
Gbak does a restore, it creates a new file, completely different from
the original, and writes the data back to the new file. Combining
the two would be sort of like taking a text file, editing it with
vi, saving it, creating a diff between the two versions, then turning
the file into a PDF and applying the diff to the pdf. Non-starter.

Good luck,

Ann